/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : erp

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 12/01/2022 10:35:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bc_order
-- ----------------------------
DROP TABLE IF EXISTS `bc_order`;
CREATE TABLE `bc_order` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `deliveryDate` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '交货日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `businessType` smallint DEFAULT '10' COMMENT '业务类型：10、订货 20、退货',
  `customerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户ID',
  `totalAmount` double DEFAULT NULL COMMENT '总金额',
  `discountedAmount` double DEFAULT NULL COMMENT '优惠后金额',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `discountRate` double DEFAULT NULL COMMENT '优惠率',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `auditorId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人ID',
  `checked` bit(1) DEFAULT b'0' COMMENT '是否已审核',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户订单';

-- ----------------------------
-- Records of bc_order
-- ----------------------------
BEGIN;
INSERT INTO `bc_order` VALUES ('1470882143742377986', '2021-12-15', '2021-12-15', 'CO2021121506202128603', 10, '1297792593699852290', 110, 110, NULL, 10, NULL, NULL, b'0', NULL, '2021-12-15 06:23:25', '2021-12-15 06:23:25');
INSERT INTO `bc_order` VALUES ('1470884100804587521', '2021-12-15', '2021-12-15', 'CO2021121506303733673', 10, '1295606388080279553', 11, 10, 111, 10, NULL, NULL, b'1', NULL, '2021-12-15 06:31:11', '2021-12-15 06:31:11');
INSERT INTO `bc_order` VALUES ('1470887604382236674', '2021-04-21', '2021-05-03', 'CO2021042106410645359', 0, '1295569375012671489', 1000, 800, 1.5, 20, '1289333755057299456', NULL, b'1', NULL, '2021-12-15 06:45:07', '2021-12-15 06:45:07');
INSERT INTO `bc_order` VALUES ('1470888235436244993', '2021-04-21', '2021-05-03', 'CO2021042106410645359', 0, '1295569375012671489', 1000, 800, 1.5, 20, '1289333755057299456', NULL, b'0', NULL, '2021-12-15 06:47:37', '2021-12-15 06:47:37');
INSERT INTO `bc_order` VALUES ('1470888452864770049', '2021-04-21', '2021-05-03', 'CO2021042106410645359', 0, '1295569375012671489', 1000, 800, 1.5, 20, '1289333755057299456', NULL, b'0', NULL, '2021-12-15 06:48:29', '2021-12-15 06:48:29');
INSERT INTO `bc_order` VALUES ('1470888780519620609', '2021-04-21', '2021-05-03', 'CO2021042106410645359', 10, '1295569375012671489', 1000, 800, 1.5, 20, '1289333755057299456', NULL, b'1', NULL, '2021-12-15 06:49:47', '2021-12-15 06:49:47');
INSERT INTO `bc_order` VALUES ('1470892097228423170', '2021-12-15', '2021-12-15', 'CO2021121507015452818', 10, '1295606388080279553', 10, 10, 11, 10, NULL, NULL, b'1', NULL, '2021-12-15 07:02:58', '2021-12-15 07:02:58');
COMMIT;

-- ----------------------------
-- Table structure for bc_purchase
-- ----------------------------
DROP TABLE IF EXISTS `bc_purchase`;
CREATE TABLE `bc_purchase` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商ID',
  `type` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型：buy、采购 refund、采购退货',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `status` smallint DEFAULT '10' COMMENT '付/退款状态：10、未付/退款 20、已付/退部分金额 30、全部付/退款',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `discountAmount` double DEFAULT NULL COMMENT '折扣额',
  `amount` double DEFAULT NULL COMMENT '购货金额',
  `preferentialRate` double DEFAULT NULL COMMENT '优惠率',
  `preferentialAmount` double DEFAULT NULL COMMENT '优惠金额',
  `preferredAmount` double DEFAULT NULL COMMENT '优惠后金额',
  `currentAmount` double DEFAULT NULL COMMENT '本次付/退款',
  `contracts` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '采购合同',
  `debtAmount` double DEFAULT NULL COMMENT '本次欠款',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `auditorId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人ID',
  `checked` bit(1) DEFAULT b'0' COMMENT '是否已审核',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='购货';

-- ----------------------------
-- Records of bc_purchase
-- ----------------------------
BEGIN;
INSERT INTO `bc_purchase` VALUES ('1298800372468236288', '1295709005540245506', 'refund', '2020-08-27', '001', 30, 10, 200, 1000, 20, 800, NULL, 0, NULL, NULL, '1292285182061146114', '1289333207897759744', b'1', '备注1', '2020-08-27 09:52:27', '2021-12-30 15:06:44');
INSERT INTO `bc_purchase` VALUES ('1299194995510415361', '1295709005540245506', 'refund', '2020-08-28', '134123413241234', 30, 11.5, 800, 1000, 20, 800, NULL, 0, '[]', NULL, '1289333755057299456', NULL, b'1', '备注2', '2020-08-28 11:59:59', '2021-12-30 15:06:48');
INSERT INTO `bc_purchase` VALUES ('1299199890892328961', '1295709005540245506', 'buy', '2020-08-28', '134123413241234', 30, 11.5, 800, 1000, 20, 800, NULL, 0, '[]', NULL, '1289333755057299456', NULL, b'1', '备注3', '2020-08-28 12:19:26', '2021-12-30 15:06:55');
INSERT INTO `bc_purchase` VALUES ('1470526255617683458', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121406484617077', 30, NULL, 0, 0, 10, 0, NULL, 0, NULL, NULL, NULL, NULL, b'1', NULL, '2021-12-14 06:49:15', '2021-12-30 15:06:56');
INSERT INTO `bc_purchase` VALUES ('1470526559264321537', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121406501342232', 30, NULL, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, b'0', NULL, '2021-12-14 06:50:27', '2021-12-30 15:06:58');
INSERT INTO `bc_purchase` VALUES ('1470528077736587265', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121406552388903', 30, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, NULL, NULL, b'0', NULL, '2021-12-14 06:56:29', '2021-12-30 15:07:01');
INSERT INTO `bc_purchase` VALUES ('1470531230410362881', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121406552388903', 30, 1, 10, 10111, 10, 10, NULL, 10, NULL, NULL, NULL, NULL, b'0', NULL, '2021-12-14 07:09:01', '2021-12-30 15:07:03');
INSERT INTO `bc_purchase` VALUES ('1470534740556271617', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121407222366713', 30, 1111, 10, 10, 10, 10, NULL, 10, NULL, NULL, NULL, NULL, b'1', NULL, '2021-12-14 07:22:58', '2021-12-30 15:07:05');
INSERT INTO `bc_purchase` VALUES ('1470535038901309441', '1297813081146834946', 'buy', '2021-12-14', 'PL2021121407235305407', 30, 1111, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, b'1', NULL, '2021-12-14 07:24:09', '2021-12-30 15:07:07');
INSERT INTO `bc_purchase` VALUES ('1470535142030856193', '1295709005540245506', 'buy', '2021-12-14', 'PL2021121407235305408', 30, 2222, 10, 10, 10, 10, NULL, 10, NULL, NULL, NULL, NULL, b'1', NULL, '2021-12-14 07:24:33', '2021-12-30 15:07:10');
INSERT INTO `bc_purchase` VALUES ('1475234369177247745', '1297813081146834946', 'buy', '2021-12-27', 'PL2021122706370455376', 0, 11, NULL, NULL, 10, 101, 10, 10, NULL, 10, NULL, NULL, b'1', NULL, '2021-12-27 06:37:36', '2021-12-30 15:07:12');
INSERT INTO `bc_purchase` VALUES ('1475237197153067010', '1295709005540245506', 'buy', '2021-12-23', 'PL2021122706482121662', 10, 11, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'1', NULL, '2021-12-27 06:48:51', '2021-12-30 15:07:14');
INSERT INTO `bc_purchase` VALUES ('1475237574371991553', '1297813081146834946', 'refund', '2021-12-28', 'PL2021122706495209548', 10, 11, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'1', NULL, '2021-12-27 06:50:20', '2021-12-30 15:06:50');
INSERT INTO `bc_purchase` VALUES ('1476388081572122626', '1295709005540245506', 'buy', '2021-12-23', 'PL2021123011013112341', 10, 111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2021-12-30 11:02:03', '2021-12-30 15:07:16');
INSERT INTO `bc_purchase` VALUES ('1476388263210651649', '1295709005540245506', 'refund', '2021-12-30', 'PL2021123011022122441', 10, 11, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2021-12-30 11:02:46', '2021-12-30 15:06:51');
INSERT INTO `bc_purchase` VALUES ('1477456276920328193', '1295709005540245506', 'buy', '2022-01-04', 'PL2022010209461434090', 10, 100, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-02 09:46:40', '2022-01-02 09:46:40');
INSERT INTO `bc_purchase` VALUES ('1477457766455607298', '1295709005540245506', 'buy', '2022-01-02', 'PL2022010209520203469', 10, 1111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-02 09:52:36', '2022-01-02 09:52:36');
INSERT INTO `bc_purchase` VALUES ('1480692961497477122', '1295709005540245506', 'buy', '2022-01-11', 'PL2022011108073227041', 10, 111, NULL, NULL, 10, 10, 10, 110, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 08:08:06', '2022-01-11 08:08:06');
INSERT INTO `bc_purchase` VALUES ('1480694097747505153', '1295709005540245506', 'buy', '2022-01-11', 'PL2022011108120994725', 10, 111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 08:12:37', '2022-01-11 08:12:37');
INSERT INTO `bc_purchase` VALUES ('1480696822379966466', '1295709005540245506', 'buy', '2022-01-11', 'PL2022011108225853528', 10, 111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 08:23:27', '2022-01-11 08:23:27');
INSERT INTO `bc_purchase` VALUES ('1480719649040232450', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011109534443054', 10, 111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 09:54:09', '2022-01-11 09:54:09');
INSERT INTO `bc_purchase` VALUES ('1480719843190370305', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011109542788886', 10, 111, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 09:54:55', '2022-01-11 09:54:55');
INSERT INTO `bc_purchase` VALUES ('1480720576917118977', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011109572019807', 10, 111, NULL, NULL, 1, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 09:57:50', '2022-01-11 09:57:50');
INSERT INTO `bc_purchase` VALUES ('1480721233279467522', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011110000098987', 10, 11, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 10:00:27', '2022-01-11 10:00:27');
INSERT INTO `bc_purchase` VALUES ('1480721652177182722', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011110013825640', 10, 11, NULL, NULL, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 10:02:07', '2022-01-11 10:02:07');
INSERT INTO `bc_purchase` VALUES ('1480723490150187009', '1297813081146834946', 'buy', '2022-01-11', 'PL2022011110090082017', 10, 111, 0, 0, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 10:09:25', '2022-01-11 10:09:25');
INSERT INTO `bc_purchase` VALUES ('1480724158248755201', '1297813081146834946', 'buy', '2022-01-12', 'PL2022011110102208654', 10, 111, 0, 0, 10, 10, 10, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-11 10:12:04', '2022-01-11 10:12:04');
INSERT INTO `bc_purchase` VALUES ('1481037847870877697', '1297813081146834946', 'buy', '2022-01-12', 'PL2022011206564146105', 10, 11, 0, 0, 0, 0, 0, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-12 06:58:33', '2022-01-12 06:58:33');
INSERT INTO `bc_purchase` VALUES ('1481038098631536641', '1297813081146834946', 'buy', '2022-01-12', 'PL2022011206591051949', 10, 11, 0, 0, 0, 0, 0, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-12 06:59:33', '2022-01-12 06:59:33');
INSERT INTO `bc_purchase` VALUES ('1481038340957450241', '1297813081146834946', 'refund', '2022-01-12', 'PL2022011207000353663', 10, 111, 0, 0, 10, 10, 10, 110, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-12 07:00:31', '2022-01-12 07:00:31');
INSERT INTO `bc_purchase` VALUES ('1481039214475763714', '1297813081146834946', 'refund', '2022-01-12', 'PL2022011207033628565', 10, 11, 0, 0, 0, 0, 0, 10, NULL, 10, NULL, NULL, b'0', NULL, '2022-01-12 07:03:59', '2022-01-12 07:03:59');
COMMIT;

-- ----------------------------
-- Table structure for bc_sale
-- ----------------------------
DROP TABLE IF EXISTS `bc_sale`;
CREATE TABLE `bc_sale` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型：buy、refund',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `customerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户ID',
  `sellerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '销售人ID：职员',
  `contactName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系人姓名',
  `address` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
  `phone` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电话号码',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `discountAmount` double DEFAULT NULL COMMENT '折扣额',
  `amount` double DEFAULT NULL COMMENT '金额',
  `preferentialRate` double DEFAULT NULL COMMENT '优惠率',
  `preferentialAmount` double DEFAULT NULL COMMENT '优惠金额',
  `preferredAmount` double DEFAULT NULL COMMENT '优惠后金额',
  `customerFee` double DEFAULT NULL COMMENT '客户费用',
  `currentAmount` double DEFAULT NULL COMMENT '本次收/退款',
  `debtAmount` double DEFAULT NULL COMMENT '本次欠款',
  `status` smallint DEFAULT NULL COMMENT '收款状态：10、未收/退款 20、部分收/退款 30、全部收/退款',
  `attachments` text COLLATE utf8mb4_general_ci COMMENT '销售附件',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `auditorId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人ID',
  `checked` bit(1) DEFAULT b'0' COMMENT '是否已审核',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='销售单';

-- ----------------------------
-- Records of bc_sale
-- ----------------------------
BEGIN;
INSERT INTO `bc_sale` VALUES ('1471260072359923713', 'sell', '2021-12-16', 'SE2021121607225508117', '1297740008892768257', '1295142029516341249', '', '11111', '11111', 111, 10, 10, NULL, 10, NULL, 10, 10, 10, NULL, NULL, NULL, NULL, b'0', NULL, '2021-12-16 07:25:10', '2021-12-30 14:20:40');
INSERT INTO `bc_sale` VALUES ('1473043894923988993', 'sell', '2021-12-21', 'SE2021122105324128819', '1471264427976871937', '1295142029516341249', '张无忌', '111', '1111', 122, NULL, 10, 10, 10, 10, 10, 10, 10, 20, NULL, NULL, NULL, b'1', NULL, '2021-12-21 05:33:27', '2021-12-30 14:20:30');
INSERT INTO `bc_sale` VALUES ('1473047284894781442', 'returned', '2021-12-21', 'RE2021122105462355098', '1471264427976871937', '1295142029516341249', '张无忌', '11', '1111', 11, NULL, 10, 10, 10, 10, 10, 10, 10, 20, NULL, NULL, NULL, b'1', NULL, '2021-12-21 05:46:55', '2021-12-30 14:20:44');
INSERT INTO `bc_sale` VALUES ('1473049734603116546', 'sell', '2021-12-22', 'SE2021122105560574726', '1297751294850375682', '1295142029516341249', NULL, '111', NULL, 1, NULL, 10, 10, 10, 10, 10, 10, 10, 20, NULL, NULL, NULL, b'0', NULL, '2021-12-21 05:56:39', '2021-12-30 14:20:36');
INSERT INTO `bc_sale` VALUES ('1476438647745060866', 'returned', '2021-12-01', 'RE2021123014220811125', '1471264427976871937', '1295142029516341249', '张无忌', '111', NULL, 11, NULL, NULL, 10, 10, 10, 10, 10, 10, 20, NULL, NULL, NULL, b'0', NULL, '2021-12-30 14:22:59', '2021-12-30 14:22:59');
INSERT INTO `bc_sale` VALUES ('1476440895887802369', 'returned', '2021-12-14', 'RE2021123014312044251', '1297751294850375682', '1295142572955648001', NULL, '22', '333', 111, NULL, NULL, 10, 10, 10, 10, 10, 10, 20, NULL, NULL, NULL, b'0', NULL, '2021-12-30 14:31:55', '2021-12-30 14:31:55');
INSERT INTO `bc_sale` VALUES ('1477458033183981569', 'sell', '2022-01-04', 'SE2022010209531428472', '1471264427976871937', '1295142029516341249', '张无忌', '111', '111', 111, NULL, NULL, 0, 0, 0, 0, 0, 0, 20, NULL, NULL, NULL, b'0', NULL, '2022-01-02 09:53:39', '2022-01-02 09:53:39');
INSERT INTO `bc_sale` VALUES ('1477458882866573313', 'sell', '2022-01-02', 'SE2022010209563459830', '1471264427976871937', '1295142029516341249', '张无忌', '111', '111', 111, NULL, NULL, 0, 0, 0, 0, 0, 0, 20, NULL, NULL, NULL, b'0', NULL, '2022-01-02 09:57:02', '2022-01-02 09:57:02');
INSERT INTO `bc_sale` VALUES ('1480724445915095041', 'sell', '2022-01-10', 'SE2022011110123808994', '1471264427976871937', '1295142029516341249', '张无忌', '1111', '11111', 111, 0, 0, 10, 10, 110, 110, 1112, 110, 20, NULL, NULL, NULL, b'0', NULL, '2022-01-11 10:13:13', '2022-01-11 10:13:13');
INSERT INTO `bc_sale` VALUES ('1481031901291520002', 'sell', '2022-01-03', 'SE2022011206341838097', '1471264427976871937', '1295142029516341249', '张无忌', '111', '111', 111, 0, 0, 0, 0, 0, 0, 10, 1000, 20, NULL, NULL, NULL, b'0', NULL, '2022-01-12 06:34:56', '2022-01-12 06:34:56');
INSERT INTO `bc_sale` VALUES ('1481032902165336066', 'returned', '2022-01-12', 'RE2022011206381859830', '1471264427976871937', '1295142029516341249', '张无忌', '11', '111', 11, 0, 0, 0, 0, 0, 0, 10, 20, 20, NULL, NULL, NULL, b'0', NULL, '2022-01-12 06:38:54', '2022-01-12 06:38:54');
COMMIT;

-- ----------------------------
-- Table structure for fc_account_record
-- ----------------------------
DROP TABLE IF EXISTS `fc_account_record`;
CREATE TABLE `fc_account_record` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `type` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型：in 收入 out 支出',
  `issueDate` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `accountId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账户ID',
  `amount` double DEFAULT '0' COMMENT '结算金额',
  `settlementType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算方式',
  `settlementCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结算号',
  `currentAmount` double DEFAULT '0' COMMENT '当前余额',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='单据账户';

-- ----------------------------
-- Records of fc_account_record
-- ----------------------------
BEGIN;
INSERT INTO `fc_account_record` VALUES ('1480699518818197505', 'in', '2022-01-11', 'collection', '1480699518482653186', '1295128579910197250', 1111, '1294752247011401730', '111', 101111, '111', '2022-01-11 08:34:10', NULL);
INSERT INTO `fc_account_record` VALUES ('1480699653644099586', 'out', '2022-01-11', 'payment', '1480699653547630594', '1295128579910197250', 2222, '1294752247011401730', '222', 98889, '222', '2022-01-11 08:34:42', NULL);
INSERT INTO `fc_account_record` VALUES ('1480723490796109826', 'out', '2022-01-11', 'buy', '1480723490150187009', '1295128579910197250', 0, NULL, NULL, 98889, NULL, '2022-01-11 10:09:25', NULL);
INSERT INTO `fc_account_record` VALUES ('1480724158638825473', 'out', '2022-01-12', 'buy', '1480724158248755201', '1295128579910197250', 10, NULL, NULL, 98879, NULL, '2022-01-11 10:12:04', NULL);
INSERT INTO `fc_account_record` VALUES ('1480724446317748225', 'in', '2022-01-10', 'sell', '1480724445915095041', '1296693080669302785', 1112, NULL, NULL, 10001112, NULL, '2022-01-11 10:13:13', NULL);
INSERT INTO `fc_account_record` VALUES ('1480725298436743170', 'in', '2022-01-11', 'income', '1480725298327691265', '1296693882423103490', 0, NULL, NULL, 10000000, NULL, '2022-01-11 10:16:36', NULL);
INSERT INTO `fc_account_record` VALUES ('1480725355827404801', 'out', '2022-01-10', 'expense', '1480725355751907330', '1296694402999144450', 330, NULL, NULL, 110781, NULL, '2022-01-11 10:16:50', NULL);
INSERT INTO `fc_account_record` VALUES ('1481031902751137794', 'in', '2022-01-03', 'sell', '1481031901291520002', '1295128579910197250', 10, NULL, NULL, 98889, NULL, '2022-01-12 06:34:56', NULL);
INSERT INTO `fc_account_record` VALUES ('1481032903029362689', 'out', '2022-01-12', 'returned', '1481032902165336066', '1295128579910197250', 10, NULL, NULL, 98879, NULL, '2022-01-12 06:38:55', NULL);
INSERT INTO `fc_account_record` VALUES ('1481034796049129473', 'in', '2022-01-12', 'collection', '1481034795910717441', '1295128579910197250', 100, '1294752247011401730', '100', 98979, NULL, '2022-01-12 06:46:26', NULL);
INSERT INTO `fc_account_record` VALUES ('1481037848449691650', 'out', '2022-01-12', 'buy', '1481037847870877697', '1295128579910197250', 10, NULL, NULL, 98969, NULL, '2022-01-12 06:58:34', NULL);
INSERT INTO `fc_account_record` VALUES ('1481038098941915138', 'out', '2022-01-12', 'buy', '1481038098631536641', '1295128579910197250', 10, NULL, NULL, 98959, NULL, '2022-01-12 06:59:33', NULL);
INSERT INTO `fc_account_record` VALUES ('1481038341532069889', 'in', '2022-01-12', 'refund', '1481038340957450241', '1295128579910197250', 110, NULL, NULL, 99069, NULL, '2022-01-12 07:00:31', NULL);
INSERT INTO `fc_account_record` VALUES ('1481039215155240961', 'in', '2022-01-12', 'refund', '1481039214475763714', '1295128579910197250', 10, NULL, NULL, 99079, NULL, '2022-01-12 07:03:59', NULL);
INSERT INTO `fc_account_record` VALUES ('1481039338522304513', 'out', '2022-01-12', 'payment', '1481039338451001346', '1295128579910197250', 111, '1294752247011401730', '111', 98968, '111', '2022-01-12 07:04:29', NULL);
INSERT INTO `fc_account_record` VALUES ('1481076991791853570', 'in', '2022-01-12', 'income', '1481076991502446593', '1295128579910197250', 110, NULL, NULL, 99078, NULL, '2022-01-12 09:34:06', NULL);
INSERT INTO `fc_account_record` VALUES ('1481077547796684801', 'in', '2022-01-12', 'income', '1481077504264003585', '1295128579910197250', 1110, NULL, NULL, 101298, NULL, '2022-01-12 09:36:19', NULL);
INSERT INTO `fc_account_record` VALUES ('1481082817617195009', 'out', '2022-01-12', 'expense', '1481082639564673025', '1295128579910197250', 2110, NULL, NULL, 98078, NULL, '2022-01-12 09:57:15', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_collection
-- ----------------------------
DROP TABLE IF EXISTS `fc_collection`;
CREATE TABLE `fc_collection` (
  `id` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `customerId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '销货单位ID',
  `collectAmount` double DEFAULT NULL COMMENT '收款金额',
  `issueAmount` double DEFAULT NULL COMMENT '单据金额',
  `discountAmount` double DEFAULT NULL COMMENT '整单折扣',
  `verifiedAmount` double DEFAULT NULL COMMENT '已核销金额',
  `unverifiedAmount` double DEFAULT NULL COMMENT '未核销金额',
  `currentVerifiedAmount` double DEFAULT NULL COMMENT '本次核销金额',
  `advanceCollectAmount` double DEFAULT NULL COMMENT '预收款',
  `listerId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收款单';

-- ----------------------------
-- Records of fc_collection
-- ----------------------------
BEGIN;
INSERT INTO `fc_collection` VALUES ('1473801084114907138', '2021-12-23', 'CL2021122307414267958', '1471264427976871937', NULL, NULL, 11, NULL, NULL, NULL, 111, NULL, NULL, '2021-12-23 07:42:15', NULL);
INSERT INTO `fc_collection` VALUES ('1473801582930898946', '2021-12-23', 'CL2021122307435267810', '1471264427976871937', NULL, NULL, 111, NULL, NULL, NULL, 11, NULL, NULL, '2021-12-23 07:44:13', NULL);
INSERT INTO `fc_collection` VALUES ('1473802440259219458', '2021-12-23', 'CL2021122307471318940', '1471264427976871937', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 07:47:38', NULL);
INSERT INTO `fc_collection` VALUES ('1473806150897057793', '2021-12-23', 'CL2021122307541116442', '1471264427976871937', NULL, NULL, 11, NULL, NULL, NULL, 22, NULL, NULL, '2021-12-23 08:02:23', NULL);
INSERT INTO `fc_collection` VALUES ('1475253027248742402', '2021-12-27', 'CL2021122707512893393', '1471264427976871937', NULL, NULL, 10, NULL, NULL, NULL, 10, NULL, NULL, '2021-12-27 07:51:45', '2021-12-27 07:51:56');
INSERT INTO `fc_collection` VALUES ('1476384714619752450', '2021-12-31', 'CL2021123010481519014', '1471264427976871937', NULL, NULL, 10, NULL, NULL, NULL, 10, NULL, NULL, '2021-12-30 10:48:40', NULL);
INSERT INTO `fc_collection` VALUES ('1480699518482653186', '2022-01-11', 'CL2022011108335247030', '1471264427976871937', NULL, NULL, 10, NULL, NULL, NULL, 110, NULL, NULL, '2022-01-11 08:34:09', NULL);
INSERT INTO `fc_collection` VALUES ('1481034795910717441', '2022-01-12', 'CL2022011206460410153', '1471264427976871937', 0, 0, 10, 0, 0, 0, 100, NULL, NULL, '2022-01-12 06:46:26', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_collection_issue
-- ----------------------------
DROP TABLE IF EXISTS `fc_collection_issue`;
CREATE TABLE `fc_collection_issue` (
  `id` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `collectionId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收款ID',
  `sourceCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '源单编码',
  `type` smallint DEFAULT NULL COMMENT '类别：10、销货 20、退货',
  `issueDate` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `issueAmount` double DEFAULT NULL COMMENT '单据金额',
  `verifiedAmount` double DEFAULT NULL COMMENT '已核销金额',
  `unverifiedAmount` double DEFAULT NULL COMMENT '未核销金额',
  `currentVerifiedAmount` double DEFAULT NULL COMMENT '本次核销金额',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收款单据';

-- ----------------------------
-- Records of fc_collection_issue
-- ----------------------------
BEGIN;
INSERT INTO `fc_collection_issue` VALUES ('1473802440628318209', '1473802440259219458', NULL, 0, NULL, NULL, NULL, NULL, NULL, '2021-12-23 07:47:38', NULL);
INSERT INTO `fc_collection_issue` VALUES ('1473802440640901121', '1473802440259219458', NULL, 0, NULL, NULL, NULL, NULL, NULL, '2021-12-23 07:47:38', NULL);
INSERT INTO `fc_collection_issue` VALUES ('1475253073335754753', '1475253027248742402', 'RE2021122105462355098', 10, '2021-12-21', 10, 0, 0, NULL, '2021-12-27 07:51:56', NULL);
INSERT INTO `fc_collection_issue` VALUES ('1476384714871410690', '1476384714619752450', 'RE2021122105462355098', 10, '2021-12-21', 10, 0, 0, NULL, '2021-12-30 10:48:40', NULL);
INSERT INTO `fc_collection_issue` VALUES ('1481034796099461121', '1481034795910717441', 'RE2021122105462355098', 10, '2021-12-21', 10, 0, 0, 0, '2022-01-12 06:46:26', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_expense
-- ----------------------------
DROP TABLE IF EXISTS `fc_expense`;
CREATE TABLE `fc_expense` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商ID',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `amount` double DEFAULT NULL COMMENT '金额',
  `paidAmount` double DEFAULT NULL COMMENT '付款金额',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支出单';

-- ----------------------------
-- Records of fc_expense
-- ----------------------------
BEGIN;
INSERT INTO `fc_expense` VALUES ('1475631186859188226', '1297813081146834946', '2021-12-28', 'ZC2021122808540257274', NULL, NULL, NULL, NULL, '2021-12-28 08:54:25', NULL);
INSERT INTO `fc_expense` VALUES ('1475631513964568577', '1295709005540245506', '2021-12-29', 'ZC2021122808552395629', NULL, 20, NULL, NULL, '2021-12-28 08:55:43', NULL);
INSERT INTO `fc_expense` VALUES ('1480725355751907330', '1297813081146834946', '2022-01-10', 'ZC2022011110163861200', 0, 330, NULL, NULL, '2022-01-11 10:16:50', NULL);
INSERT INTO `fc_expense` VALUES ('1481082639564673025', '1297813081146834946', '2022-01-12', 'ZC2022011209562225307', 0, 2110, NULL, NULL, '2022-01-12 09:56:33', '2022-01-12 09:57:15');
COMMIT;

-- ----------------------------
-- Table structure for fc_flow_record
-- ----------------------------
DROP TABLE IF EXISTS `fc_flow_record`;
CREATE TABLE `fc_flow_record` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `categoryId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类别ID',
  `amount` double DEFAULT '0' COMMENT '金额',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收支记录';

-- ----------------------------
-- Records of fc_flow_record
-- ----------------------------
BEGIN;
INSERT INTO `fc_flow_record` VALUES ('1475625436262883330', NULL, 'income', '1475625436065751042', '1293524307846103041', 11, '111', '2021-12-28 08:31:34', '2022-01-12 09:26:54');
INSERT INTO `fc_flow_record` VALUES ('1475625436267077634', NULL, 'income', '1475625436065751042', '1293524330184966146', 222, '111', '2021-12-28 08:31:34', '2022-01-12 09:26:55');
INSERT INTO `fc_flow_record` VALUES ('1475628376423849985', NULL, 'income', '1475626609342603265', '1293524307846103041', 111, '22', '2021-12-28 08:43:15', '2022-01-12 09:26:56');
INSERT INTO `fc_flow_record` VALUES ('1475631739819450369', NULL, 'income', '1475631739563597825', '1293524307846103041', 11, '22', '2021-12-28 08:56:37', '2022-01-12 09:26:58');
INSERT INTO `fc_flow_record` VALUES ('1480725298453520385', NULL, 'income', '1480725298327691265', '1293524307846103041', 22, '2222', '2022-01-11 10:16:36', '2022-01-12 09:26:59');
INSERT INTO `fc_flow_record` VALUES ('1481076991837990914', NULL, 'income', '1481076991502446593', '1293524307846103041', 1111, '111', '2022-01-12 09:34:06', NULL);
INSERT INTO `fc_flow_record` VALUES ('1481077547817656321', '2022-01-12', 'income', '1481077504264003585', '1293524307846103041', 1111, '11', '2022-01-12 09:36:19', NULL);
INSERT INTO `fc_flow_record` VALUES ('1481077547834433537', '2022-01-12', 'income', '1481077504264003585', '1293524330184966146', 222, '1111', '2022-01-12 09:36:19', NULL);
INSERT INTO `fc_flow_record` VALUES ('1481082817650749442', '2022-01-12', 'expense', '1481082639564673025', '1293524150584868866', 111, '11111', '2022-01-12 09:57:15', NULL);
INSERT INTO `fc_flow_record` VALUES ('1481082817659138050', '2022-01-12', 'expense', '1481082639564673025', '1293524198936805378', 222, '2222', '2022-01-12 09:57:15', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_income
-- ----------------------------
DROP TABLE IF EXISTS `fc_income`;
CREATE TABLE `fc_income` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `customerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '销货单位ID',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `amount` double DEFAULT NULL COMMENT '金额',
  `collectAmount` double DEFAULT NULL COMMENT '收款金额',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收入单';

-- ----------------------------
-- Records of fc_income
-- ----------------------------
BEGIN;
INSERT INTO `fc_income` VALUES ('1475625436065751042', '1471264427976871937', '2021-12-28', 'SR2021122808300451396', NULL, 110, NULL, NULL, '2021-12-28 08:31:34', NULL);
INSERT INTO `fc_income` VALUES ('1475626609342603265', '1471264427976871937', '2021-12-30', 'SR2021122808355781473', NULL, 10, NULL, NULL, '2021-12-28 08:36:14', '2021-12-28 08:43:15');
INSERT INTO `fc_income` VALUES ('1475631739563597825', '1471264427976871937', '2021-12-22', 'SR2021122808562596504', NULL, 110, NULL, NULL, '2021-12-28 08:56:37', NULL);
INSERT INTO `fc_income` VALUES ('1480725298327691265', '1471264427976871937', '2022-01-11', 'SR2022011110162633090', 0, 0, NULL, NULL, '2022-01-11 10:16:36', NULL);
INSERT INTO `fc_income` VALUES ('1481076991502446593', '1471264427976871937', '2022-01-12', 'SR2022011209335224219', 0, 110, NULL, NULL, '2022-01-12 09:34:06', NULL);
INSERT INTO `fc_income` VALUES ('1481077504264003585', '1471264427976871937', '2022-01-12', 'SR2022011209355637075', 0, 1110, NULL, NULL, '2022-01-12 09:36:08', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_payable
-- ----------------------------
DROP TABLE IF EXISTS `fc_payable`;
CREATE TABLE `fc_payable` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商ID',
  `issueDate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `increasedAmount` double DEFAULT '0' COMMENT '增加应付款金额',
  `paidAmount` double DEFAULT '0' COMMENT '支付应付款金额',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='应付账款记录';

-- ----------------------------
-- Records of fc_payable
-- ----------------------------
BEGIN;
INSERT INTO `fc_payable` VALUES ('1481038098967080961', '1297813081146834946', '2022-01-12', 'buy', '1481038098631536641', 10, 0, '2022-01-12 06:59:33', NULL);
INSERT INTO `fc_payable` VALUES ('1481038341565624322', '1297813081146834946', '2022-01-12', 'buy', '1481038340957450241', -10, 0, '2022-01-12 07:00:31', NULL);
INSERT INTO `fc_payable` VALUES ('1481039215184601090', '1297813081146834946', '2022-01-12', 'refund', '1481039214475763714', -10, 0, '2022-01-12 07:03:59', NULL);
INSERT INTO `fc_payable` VALUES ('1481039338597801985', '1297813081146834946', '2022-01-12', 'payment', '1481039338451001346', 0, 110, '2022-01-12 07:04:29', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_payment
-- ----------------------------
DROP TABLE IF EXISTS `fc_payment`;
CREATE TABLE `fc_payment` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '购货单位ID',
  `paidAmount` double DEFAULT NULL COMMENT '付款金额',
  `issueAmount` double DEFAULT NULL COMMENT '单据金额',
  `discountAmount` double DEFAULT NULL COMMENT '整单折扣',
  `verifiedAmount` double DEFAULT NULL COMMENT '已核销金额',
  `unverifiedAmount` double DEFAULT NULL COMMENT '未核销金额',
  `currentVerifiedAmount` double DEFAULT NULL COMMENT '本次核销金额',
  `advancePaidAmount` double DEFAULT NULL COMMENT '预付款',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='付款单';

-- ----------------------------
-- Records of fc_payment
-- ----------------------------
BEGIN;
INSERT INTO `fc_payment` VALUES ('1475253186007343105', '2021-12-28', 'FK2021122707520065067', '1295709005540245506', NULL, NULL, 10, NULL, NULL, NULL, 10, NULL, NULL, '2021-12-27 07:52:23', NULL);
INSERT INTO `fc_payment` VALUES ('1476385905966170114', '2021-12-29', 'FK2021123010530685097', '1297813081146834946', NULL, NULL, 10, NULL, NULL, NULL, 10, NULL, NULL, '2021-12-30 10:53:24', NULL);
INSERT INTO `fc_payment` VALUES ('1480699653547630594', '2022-01-11', 'FK2022011108342533669', '1295709005540245506', NULL, NULL, 20, NULL, NULL, NULL, 2220, NULL, NULL, '2022-01-11 08:34:42', NULL);
INSERT INTO `fc_payment` VALUES ('1481039338451001346', '2022-01-12', 'FK2022011207041183517', '1297813081146834946', 0, 0, 10, 0, 0, 0, 110, NULL, NULL, '2022-01-12 07:04:29', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_payment_issue
-- ----------------------------
DROP TABLE IF EXISTS `fc_payment_issue`;
CREATE TABLE `fc_payment_issue` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `paymentId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '付款ID',
  `sourceCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '源单编码',
  `type` smallint DEFAULT NULL COMMENT '类别：10、购货 20、购货退货',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `issueAmount` double DEFAULT NULL COMMENT '单据金额',
  `verifiedAmount` double DEFAULT NULL COMMENT '已核销金额',
  `unverifiedAmount` double DEFAULT NULL COMMENT '未核销金额',
  `currentVerifiedAmount` double DEFAULT NULL COMMENT '本次核销金额',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='付款单据';

-- ----------------------------
-- Records of fc_payment_issue
-- ----------------------------
BEGIN;
INSERT INTO `fc_payment_issue` VALUES ('1475253186187698177', '1475253186007343105', 'PL2021122706482121662', 10, '2021-12-23', NULL, 0, 0, 111, '2021-12-27 07:52:23', NULL);
INSERT INTO `fc_payment_issue` VALUES ('1476385906427543553', '1476385905966170114', 'PL2021122706370455376', 10, '2021-12-27', NULL, 0, 0, NULL, '2021-12-30 10:53:24', NULL);
INSERT INTO `fc_payment_issue` VALUES ('1481039338564247554', '1481039338451001346', 'PL2021122706370455376', 10, '2021-12-27', 0, 0, 0, 0, '2022-01-12 07:04:29', NULL);
COMMIT;

-- ----------------------------
-- Table structure for fc_receivable
-- ----------------------------
DROP TABLE IF EXISTS `fc_receivable`;
CREATE TABLE `fc_receivable` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `customerId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户ID',
  `issueDate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `increasedAmount` double DEFAULT '0' COMMENT '增加应收款金额',
  `paidAmount` double DEFAULT '0' COMMENT '支付应收款金额',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='应收账款记录';

-- ----------------------------
-- Records of fc_receivable
-- ----------------------------
BEGIN;
INSERT INTO `fc_receivable` VALUES ('1481031902784692226', '1471264427976871937', '2022-01-03', 'sell', '1481031901291520002', 1000, 0, '2022-01-12 06:34:56', NULL);
INSERT INTO `fc_receivable` VALUES ('1481032903121637378', '1471264427976871937', '2022-01-12', 'returned', '1481032902165336066', -20, 0, '2022-01-12 06:38:55', NULL);
INSERT INTO `fc_receivable` VALUES ('1481034796158181378', '1471264427976871937', '2022-01-12', 'collection', '1481034795910717441', 0, 0, '2022-01-12 06:46:26', NULL);
COMMIT;

-- ----------------------------
-- Table structure for rc_category
-- ----------------------------
DROP TABLE IF EXISTS `rc_category`;
CREATE TABLE `rc_category` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `type` smallint DEFAULT NULL COMMENT '类型',
  `parentId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `sortNumber` int DEFAULT NULL COMMENT '排序',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='类别';

-- ----------------------------
-- Records of rc_category
-- ----------------------------
BEGIN;
INSERT INTO `rc_category` VALUES ('1', 10, NULL, '长山湖沃尔玛', 0, '2020-08-12 19:19:07', '2020-08-12 19:53:08');
INSERT INTO `rc_category` VALUES ('1292435079284391938', 30, NULL, '苹果6666666666666666', 0, '2020-08-09 20:18:29', '2020-08-12 19:47:14');
INSERT INTO `rc_category` VALUES ('1292436543931158529', 30, '1292435079284391938', '甜心苹果真', 0, '2020-08-09 20:24:19', '2020-08-09 20:25:23');
INSERT INTO `rc_category` VALUES ('1292436921745793026', 30, '1292435079284391938', '美国蛇果', 0, '2020-08-09 20:25:49', '2020-08-09 20:25:49');
INSERT INTO `rc_category` VALUES ('1293513956037320706', 10, NULL, '永辉', 0, '2020-08-12 19:45:34', '2020-08-12 19:47:14');
INSERT INTO `rc_category` VALUES ('1293515038924996609', 10, NULL, '物美', 0, '2020-08-12 19:49:52', '2020-08-12 19:51:15');
INSERT INTO `rc_category` VALUES ('1293515709078347777', 10, NULL, '惠航', 0, '2020-08-12 19:52:32', '2020-08-12 19:52:32');
INSERT INTO `rc_category` VALUES ('1293515949160308738', 10, NULL, '惠好', 0, '2020-08-12 19:53:29', '2020-08-12 19:53:29');
INSERT INTO `rc_category` VALUES ('1293524002781790209', 30, NULL, '香蕉', 0, '2020-08-12 20:25:29', '2020-08-12 20:25:29');
INSERT INTO `rc_category` VALUES ('1293524150584868866', 40, NULL, '文具', 0, '2020-08-12 20:26:04', '2020-08-12 20:26:04');
INSERT INTO `rc_category` VALUES ('1293524175704555521', 40, NULL, '家具', 0, '2020-08-12 20:26:10', '2020-08-12 20:26:10');
INSERT INTO `rc_category` VALUES ('1293524198936805378', 40, NULL, '日常', 0, '2020-08-12 20:26:16', '2020-08-12 20:26:16');
INSERT INTO `rc_category` VALUES ('1293524307846103041', 50, NULL, '销售', 0, '2020-08-12 20:26:42', '2020-08-12 20:26:42');
INSERT INTO `rc_category` VALUES ('1293524330184966146', 50, NULL, '回扣', 0, '2020-08-12 20:26:47', '2020-08-12 20:26:47');
INSERT INTO `rc_category` VALUES ('1293527068016902146', 20, NULL, '南通市场', 0, '2020-08-12 20:37:40', '2020-08-12 20:37:40');
INSERT INTO `rc_category` VALUES ('1293528816009871362', 30, '1292435079284391938', '呵呵', 0, '2020-08-12 20:44:37', '2020-08-12 20:44:37');
INSERT INTO `rc_category` VALUES ('1293528871613759489', 30, '1293524002781790209', '不错', 0, '2020-08-12 20:44:50', '2020-08-12 20:44:50');
INSERT INTO `rc_category` VALUES ('1293530532960796673', 30, '1293524002781790209', '皇帝蕉', 0, '2020-08-12 20:51:26', '2020-08-12 20:51:26');
INSERT INTO `rc_category` VALUES ('1293530579928612865', 30, '1293524002781790209', '米蕉', 0, '2020-08-12 20:51:37', '2020-08-12 20:51:37');
INSERT INTO `rc_category` VALUES ('1293530704453304321', 30, '1293524002781790209', '草莓', 0, '2020-08-12 20:52:07', '2020-08-12 20:52:07');
INSERT INTO `rc_category` VALUES ('1293530765350404097', 10, NULL, '客户1', 0, '2020-08-12 20:52:21', '2020-08-12 20:52:21');
INSERT INTO `rc_category` VALUES ('1293530793213165569', 30, '1293524002781790209', '草莓', 0, '2020-08-12 20:52:28', '2020-08-12 20:52:28');
INSERT INTO `rc_category` VALUES ('1293531501958266881', 30, NULL, '草莓', 0, '2020-08-12 20:55:17', '2020-08-12 20:55:17');
INSERT INTO `rc_category` VALUES ('1293531538306105346', 30, '1293531501958266881', '野草莓', 0, '2020-08-12 20:55:26', '2020-08-12 20:55:26');
INSERT INTO `rc_category` VALUES ('1293531582908334081', 30, NULL, '西瓜', 0, '2020-08-12 20:55:36', '2020-08-12 20:55:36');
INSERT INTO `rc_category` VALUES ('1293531612016803841', 30, '1293531582908334081', '硒砂瓜', 0, '2020-08-12 20:55:43', '2020-08-12 20:55:43');
INSERT INTO `rc_category` VALUES ('1293531662331674625', 50, NULL, '退税', 0, '2020-08-12 20:55:55', '2020-08-12 20:55:55');
INSERT INTO `rc_category` VALUES ('1293531717222531074', 30, '1293531582908334081', '8424瓜', 0, '2020-08-12 20:56:08', '2020-08-12 20:56:08');
INSERT INTO `rc_category` VALUES ('1293532083502710786', 30, '1293530579928612865', '米蕉1号', 0, '2020-08-12 20:57:36', '2020-08-12 20:57:36');
INSERT INTO `rc_category` VALUES ('1296692657996705793', 10, NULL, '客户2', 0, '2020-08-21 14:16:35', '2020-08-21 14:16:35');
INSERT INTO `rc_category` VALUES ('1297806472534364162', 20, NULL, '南区市场', 0, '2020-08-24 16:02:29', '2020-08-24 16:02:29');
INSERT INTO `rc_category` VALUES ('1297806511738523650', 20, NULL, '海峡市场', 0, '2020-08-24 16:02:39', '2020-08-24 16:02:39');
INSERT INTO `rc_category` VALUES ('2', 10, NULL, '大润发', 0, '2020-08-12 19:19:35', '2020-08-12 19:53:10');
COMMIT;

-- ----------------------------
-- Table structure for rc_dict
-- ----------------------------
DROP TABLE IF EXISTS `rc_dict`;
CREATE TABLE `rc_dict` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编码',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典表';

-- ----------------------------
-- Records of rc_dict
-- ----------------------------
BEGIN;
INSERT INTO `rc_dict` VALUES ('1294755128108150784', '计量单位', 'unit', '2020-08-10 07:20:03', '2020-08-16 05:57:47');
INSERT INTO `rc_dict` VALUES ('1294755227492220928', '结算方式', 'settlement', '2020-08-10 07:20:19', '2020-08-16 05:58:02');
INSERT INTO `rc_dict` VALUES ('1294755272174112768', '客户等级', 'customer_level', '2020-08-10 07:20:41', '2020-08-16 05:58:12');
INSERT INTO `rc_dict` VALUES ('1294755319368437760', '账户类别', 'account_type', '2020-08-16 05:58:37', '2020-08-16 05:58:37');
COMMIT;

-- ----------------------------
-- Table structure for rc_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `rc_dict_item`;
CREATE TABLE `rc_dict_item` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `dictCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典编码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `sortNumber` int DEFAULT '0' COMMENT '排序',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典项';

-- ----------------------------
-- Records of rc_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `rc_dict_item` VALUES ('1292601852277293057', 'unit', '斤', 0, '2020-08-10 07:21:11', '2020-08-10 07:21:11');
INSERT INTO `rc_dict_item` VALUES ('1292601958565150721', 'unit', '包', 0, '2020-08-10 07:21:36', '2020-08-10 07:21:36');
INSERT INTO `rc_dict_item` VALUES ('1292602021718786049', 'unit', '盒', 0, '2020-08-10 07:21:52', '2020-08-10 07:21:52');
INSERT INTO `rc_dict_item` VALUES ('1294752247011401730', 'settlement', '现金', 0, '2020-08-16 05:46:05', '2020-08-16 05:46:05');
INSERT INTO `rc_dict_item` VALUES ('1294752312320909313', 'settlement', '转账', 0, '2020-08-16 05:46:21', '2020-08-21 14:10:45');
INSERT INTO `rc_dict_item` VALUES ('1294753269708566530', 'customer_level', '零售客户', 0, '2020-08-16 05:50:09', '2020-08-16 05:50:09');
INSERT INTO `rc_dict_item` VALUES ('1294753575536242689', 'customer_level', '批发客户', 0, '2020-08-16 05:51:22', '2020-08-16 05:51:22');
INSERT INTO `rc_dict_item` VALUES ('1294753669664813058', 'customer_level', 'VIP客户', 0, '2020-08-16 05:51:44', '2020-08-16 05:51:44');
INSERT INTO `rc_dict_item` VALUES ('1294753770302943233', 'customer_level', '折扣等级一', 0, '2020-08-16 05:52:08', '2020-08-16 05:52:08');
INSERT INTO `rc_dict_item` VALUES ('1294753825122496514', 'customer_level', '折扣等级二', 0, '2020-08-16 05:52:21', '2020-08-16 05:52:21');
INSERT INTO `rc_dict_item` VALUES ('1294764297926311938', 'account_type', '现金', 0, '2020-08-16 06:33:58', '2020-08-16 06:33:58');
INSERT INTO `rc_dict_item` VALUES ('1294765881575636993', 'account_type', '银行存款', 0, '2020-08-16 06:40:16', '2020-08-16 06:40:16');
INSERT INTO `rc_dict_item` VALUES ('1296969005835337730', 'unit', '把', 0, '2020-08-22 08:34:42', '2020-08-22 08:34:42');
INSERT INTO `rc_dict_item` VALUES ('1296969033928785922', 'unit', '听', 0, '2020-08-22 08:34:48', '2020-08-22 08:34:48');
INSERT INTO `rc_dict_item` VALUES ('1296969064484290562', 'unit', '扎', 0, '2020-08-22 08:34:56', '2020-08-22 08:34:56');
COMMIT;

-- ----------------------------
-- Table structure for rc_key_value
-- ----------------------------
DROP TABLE IF EXISTS `rc_key_value`;
CREATE TABLE `rc_key_value` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `key` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '键',
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '值',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型',
  `reservedInt` int NOT NULL DEFAULT '0' COMMENT '保留的int字段',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='键值对';

-- ----------------------------
-- Records of rc_key_value
-- ----------------------------
BEGIN;
INSERT INTO `rc_key_value` VALUES ('1292284802837344258', 'system_configuration', '{\"checkNegativeStock\":false,\"companyAddress\":\"福建福州长乐\",\"companyFax\":\"0591-88888888\",\"companyName\":\"福州精博网络科技有限公司\",\"companyPhone\":\"18905013333\",\"companyPostCode\":\"350200\",\"currency\":\"RMB\",\"inventoryValuationMethod\":10,\"pricePrecision\":3,\"quantityPrecision\":3,\"startTime\":1596963649000}', 'settings', 0, '2020-08-09 17:01:23', '2020-08-12 09:28:48');
COMMIT;

-- ----------------------------
-- Table structure for rc_log
-- ----------------------------
DROP TABLE IF EXISTS `rc_log`;
CREATE TABLE `rc_log` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `type` smallint DEFAULT NULL COMMENT '类型',
  `userId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作用户ID',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作用户名',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作用户姓名',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '操作内容',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统日志';

-- ----------------------------
-- Records of rc_log
-- ----------------------------
BEGIN;
INSERT INTO `rc_log` VALUES ('1', 10000, '1289333755057299456', 'chenwei', '陈伟', NULL, NULL, NULL);
INSERT INTO `rc_log` VALUES ('1292284802837344258', 10000, NULL, NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-09 10:21:21', '2020-08-09 10:21:21');
INSERT INTO `rc_log` VALUES ('1292285182472187905', 11010, '1291929781444599810', 'cwyd0822', '张三', '{\"username\":\"chenwei\"}', '2020-08-09 10:22:51', '2020-08-09 10:22:51');
INSERT INTO `rc_log` VALUES ('1292626685128081410', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 08:59:52', '2020-08-10 08:59:52');
INSERT INTO `rc_log` VALUES ('1292627676472803329', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:03:48', '2020-08-10 09:03:48');
INSERT INTO `rc_log` VALUES ('1292627900842901506', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:04:42', '2020-08-10 09:04:42');
INSERT INTO `rc_log` VALUES ('1292628042253860865', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:05:15', '2020-08-10 09:05:15');
INSERT INTO `rc_log` VALUES ('1292632923345780738', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:24:39', '2020-08-10 09:24:39');
INSERT INTO `rc_log` VALUES ('1292633457616322561', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:26:46', '2020-08-10 09:26:46');
INSERT INTO `rc_log` VALUES ('1292635339420172289', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:34:15', '2020-08-10 09:34:15');
INSERT INTO `rc_log` VALUES ('1292635824545955841', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:36:11', '2020-08-10 09:36:11');
INSERT INTO `rc_log` VALUES ('1292636198073892866', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:37:40', '2020-08-10 09:37:40');
INSERT INTO `rc_log` VALUES ('1292637700374679554', 10000, '0', NULL, NULL, '{\"username\":\"cwyd0822\"}', '2020-08-10 09:43:38', '2020-08-10 09:43:38');
INSERT INTO `rc_log` VALUES ('1292638425922162689', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 09:46:31', '2020-08-10 09:46:31');
INSERT INTO `rc_log` VALUES ('1292642622451580929', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:03:11', '2020-08-10 10:03:11');
INSERT INTO `rc_log` VALUES ('1292644482197585922', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:10:35', '2020-08-10 10:10:35');
INSERT INTO `rc_log` VALUES ('1292644657437405185', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:11:17', '2020-08-10 10:11:17');
INSERT INTO `rc_log` VALUES ('1292644847250632706', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:12:02', '2020-08-10 10:12:02');
INSERT INTO `rc_log` VALUES ('1292645427090305026', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:14:20', '2020-08-10 10:14:20');
INSERT INTO `rc_log` VALUES ('1292646532794593281', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:18:44', '2020-08-10 10:18:44');
INSERT INTO `rc_log` VALUES ('1292647331438653441', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:21:54', '2020-08-10 10:21:54');
INSERT INTO `rc_log` VALUES ('1292648347559129090', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:25:56', '2020-08-10 10:25:56');
INSERT INTO `rc_log` VALUES ('1292648374067130370', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:26:03', '2020-08-10 10:26:03');
INSERT INTO `rc_log` VALUES ('1292648569135702018', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:26:49', '2020-08-10 10:26:49');
INSERT INTO `rc_log` VALUES ('1292648818373832706', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:27:49', '2020-08-10 10:27:49');
INSERT INTO `rc_log` VALUES ('1292653846912303105', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-10 10:47:48', '2020-08-10 10:47:48');
INSERT INTO `rc_log` VALUES ('1292662273323565058', 11010, '1291929781444599810', 'admin', '张三', '{\"username\":\"zhangsan\"}', '2020-08-10 11:21:17', '2020-08-10 11:21:17');
INSERT INTO `rc_log` VALUES ('1292662850648641538', 10000, '0', NULL, NULL, '{\"username\":\"zhangsan\"}', '2020-08-10 11:23:34', '2020-08-10 11:23:34');
INSERT INTO `rc_log` VALUES ('1293110943026331649', 10000, '0', NULL, NULL, '{\"username\":\"admin\"}', '2020-08-11 17:04:08', '2020-08-11 17:04:08');
INSERT INTO `rc_log` VALUES ('1293111137621065729', 11010, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:04:54', '2020-08-11 17:04:54');
INSERT INTO `rc_log` VALUES ('1293120766375673857', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-11 17:43:10', '2020-08-11 17:43:10');
INSERT INTO `rc_log` VALUES ('1293120794603339778', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:43:17', '2020-08-11 17:43:17');
INSERT INTO `rc_log` VALUES ('1293120805680496641', 11020, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:43:19', '2020-08-11 17:43:19');
INSERT INTO `rc_log` VALUES ('1293120814144602114', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:43:21', '2020-08-11 17:43:21');
INSERT INTO `rc_log` VALUES ('1293120818766725121', 11020, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:43:22', '2020-08-11 17:43:22');
INSERT INTO `rc_log` VALUES ('1293124488925331458', 11040, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 17:57:57', '2020-08-11 17:57:57');
INSERT INTO `rc_log` VALUES ('1293134400241844226', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 18:37:20', '2020-08-11 18:37:20');
INSERT INTO `rc_log` VALUES ('1293134821345792002', 11020, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-11 18:39:01', '2020-08-11 18:39:01');
INSERT INTO `rc_log` VALUES ('1293135171855388673', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"zhangsan\"}', '2020-08-11 18:40:24', '2020-08-11 18:40:24');
INSERT INTO `rc_log` VALUES ('1293215718401167361', 11020, '1291929781444599810', 'admin', '张三', '{\"username\":\"zhangsan\"}', '2020-08-12 00:00:28', '2020-08-12 00:00:28');
INSERT INTO `rc_log` VALUES ('1293505763504644097', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-12 19:13:00', '2020-08-12 19:13:00');
INSERT INTO `rc_log` VALUES ('1296630297388691458', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-21 10:08:47', '2020-08-21 10:08:47');
INSERT INTO `rc_log` VALUES ('1296728348449320962', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"zhangsan\"}', '2020-08-21 16:38:24', '2020-08-21 16:38:24');
INSERT INTO `rc_log` VALUES ('1296728352220000257', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"chenwei\"}', '2020-08-21 16:38:25', '2020-08-21 16:38:25');
INSERT INTO `rc_log` VALUES ('1296728356473024513', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"admin\"}', '2020-08-21 16:38:26', '2020-08-21 16:38:26');
INSERT INTO `rc_log` VALUES ('1296728359920742402', 11030, '1291929781444599810', 'admin', '张三', '{\"username\":\"lisi11\"}', '2020-08-21 16:38:27', '2020-08-21 16:38:27');
INSERT INTO `rc_log` VALUES ('1297005465330311169', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-22 10:59:34', '2020-08-22 10:59:34');
INSERT INTO `rc_log` VALUES ('1297012201223151617', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-22 11:26:20', '2020-08-22 11:26:20');
INSERT INTO `rc_log` VALUES ('1297360541544472578', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-23 10:30:31', '2020-08-23 10:30:31');
INSERT INTO `rc_log` VALUES ('1297708875790524417', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-24 09:34:40', '2020-08-24 09:34:40');
INSERT INTO `rc_log` VALUES ('1298429228842037250', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-26 09:17:06', '2020-08-26 09:17:06');
INSERT INTO `rc_log` VALUES ('1298770607631822850', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-27 07:53:37', '2020-08-27 07:53:37');
INSERT INTO `rc_log` VALUES ('1299153748800376834', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-28 09:16:05', '2020-08-28 09:16:05');
INSERT INTO `rc_log` VALUES ('1299154465648873474', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-28 09:18:56', '2020-08-28 09:18:56');
INSERT INTO `rc_log` VALUES ('1299188409467424770', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-28 11:33:49', '2020-08-28 11:33:49');
INSERT INTO `rc_log` VALUES ('1299244140640092162', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-08-28 15:15:16', '2020-08-28 15:15:16');
INSERT INTO `rc_log` VALUES ('1300674867772579841', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-09-01 14:00:28', '2020-09-01 14:00:28');
INSERT INTO `rc_log` VALUES ('1300676300102230017', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-09-01 14:06:10', '2020-09-01 14:06:10');
INSERT INTO `rc_log` VALUES ('1315059730663440386', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-10-11 06:40:47', '2020-10-11 06:40:47');
INSERT INTO `rc_log` VALUES ('1315063036588687362', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2020-10-11 06:53:55', '2020-10-11 06:53:55');
INSERT INTO `rc_log` VALUES ('1383530983185186818', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-04-18 05:21:05', '2021-04-18 05:21:05');
INSERT INTO `rc_log` VALUES ('1383982160146333697', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-04-19 11:13:54', '2021-04-19 11:13:54');
INSERT INTO `rc_log` VALUES ('1384284140911833089', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-04-20 07:13:52', '2021-04-20 07:13:52');
INSERT INTO `rc_log` VALUES ('1462710674701086722', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-11-22 17:12:55', '2021-11-22 17:12:55');
INSERT INTO `rc_log` VALUES ('1463079341225873410', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-11-23 17:37:52', '2021-11-23 17:37:52');
INSERT INTO `rc_log` VALUES ('1463320586078552065', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-11-24 09:36:29', '2021-11-24 09:36:29');
INSERT INTO `rc_log` VALUES ('1463321003013341186', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-11-24 09:38:08', '2021-11-24 09:38:08');
INSERT INTO `rc_log` VALUES ('1463323724776910850', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-11-24 09:48:57', '2021-11-24 09:48:57');
INSERT INTO `rc_log` VALUES ('1468342015190790145', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-08 06:09:51', '2021-12-08 06:09:51');
INSERT INTO `rc_log` VALUES ('1468348957166571522', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-08 06:37:26', '2021-12-08 06:37:26');
INSERT INTO `rc_log` VALUES ('1469052528421933058', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:13:11', '2021-12-10 05:13:11');
INSERT INTO `rc_log` VALUES ('1469054542472187906', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:21:11', '2021-12-10 05:21:11');
INSERT INTO `rc_log` VALUES ('1469056490407628801', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:28:55', '2021-12-10 05:28:55');
INSERT INTO `rc_log` VALUES ('1469056653993873410', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:29:34', '2021-12-10 05:29:34');
INSERT INTO `rc_log` VALUES ('1469063589673996290', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:57:08', '2021-12-10 05:57:08');
INSERT INTO `rc_log` VALUES ('1469063660884889601', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:57:25', '2021-12-10 05:57:25');
INSERT INTO `rc_log` VALUES ('1469063700995018753', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 05:57:34', '2021-12-10 05:57:34');
INSERT INTO `rc_log` VALUES ('1469065746989096962', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:05:42', '2021-12-10 06:05:42');
INSERT INTO `rc_log` VALUES ('1469065860570849282', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:06:09', '2021-12-10 06:06:09');
INSERT INTO `rc_log` VALUES ('1469066503335354370', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:08:43', '2021-12-10 06:08:43');
INSERT INTO `rc_log` VALUES ('1469066781904281601', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:09:49', '2021-12-10 06:09:49');
INSERT INTO `rc_log` VALUES ('1469066906898735105', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:10:19', '2021-12-10 06:10:19');
INSERT INTO `rc_log` VALUES ('1469067102135197698', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:11:05', '2021-12-10 06:11:05');
INSERT INTO `rc_log` VALUES ('1469067300420919297', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:11:53', '2021-12-10 06:11:53');
INSERT INTO `rc_log` VALUES ('1469067368477696002', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:12:09', '2021-12-10 06:12:09');
INSERT INTO `rc_log` VALUES ('1469067377512226817', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:12:11', '2021-12-10 06:12:11');
INSERT INTO `rc_log` VALUES ('1469067452783206401', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 06:12:29', '2021-12-10 06:12:29');
INSERT INTO `rc_log` VALUES ('1469127058909765633', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-10 10:09:20', '2021-12-10 10:09:20');
INSERT INTO `rc_log` VALUES ('1470179100860243970', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 07:49:46', '2021-12-13 07:49:46');
INSERT INTO `rc_log` VALUES ('1470180430949539842', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 07:55:04', '2021-12-13 07:55:04');
INSERT INTO `rc_log` VALUES ('1470180555843379202', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 07:55:33', '2021-12-13 07:55:33');
INSERT INTO `rc_log` VALUES ('1470180556069871618', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 07:55:33', '2021-12-13 07:55:33');
INSERT INTO `rc_log` VALUES ('1470182580110909441', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:03:36', '2021-12-13 08:03:36');
INSERT INTO `rc_log` VALUES ('1470183180852682754', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:05:59', '2021-12-13 08:05:59');
INSERT INTO `rc_log` VALUES ('1470183377976582146', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:06:46', '2021-12-13 08:06:46');
INSERT INTO `rc_log` VALUES ('1470183989346721793', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:09:12', '2021-12-13 08:09:12');
INSERT INTO `rc_log` VALUES ('1470184149975982082', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:09:50', '2021-12-13 08:09:50');
INSERT INTO `rc_log` VALUES ('1470184758221365249', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:12:15', '2021-12-13 08:12:15');
INSERT INTO `rc_log` VALUES ('1470185410603409410', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:14:51', '2021-12-13 08:14:51');
INSERT INTO `rc_log` VALUES ('1470187147825405954', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:21:45', '2021-12-13 08:21:45');
INSERT INTO `rc_log` VALUES ('1470189008431267842', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 08:29:09', '2021-12-13 08:29:09');
INSERT INTO `rc_log` VALUES ('1470377764878696450', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-13 20:59:12', '2021-12-13 20:59:12');
INSERT INTO `rc_log` VALUES ('1470526068010659841', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-14 06:48:30', '2021-12-14 06:48:30');
INSERT INTO `rc_log` VALUES ('1470532711242944514', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-14 07:14:54', '2021-12-14 07:14:54');
INSERT INTO `rc_log` VALUES ('1470555490617098241', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-14 08:45:25', '2021-12-14 08:45:25');
INSERT INTO `rc_log` VALUES ('1470723232062136322', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-14 19:51:57', '2021-12-14 19:51:57');
INSERT INTO `rc_log` VALUES ('1470878135564812289', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-15 06:07:29', '2021-12-15 06:07:29');
INSERT INTO `rc_log` VALUES ('1471005758865444866', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-15 14:34:37', '2021-12-15 14:34:37');
INSERT INTO `rc_log` VALUES ('1471674856523866113', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-17 10:53:22', '2021-12-17 10:53:22');
INSERT INTO `rc_log` VALUES ('1471675106374361089', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-17 10:54:22', '2021-12-17 10:54:22');
INSERT INTO `rc_log` VALUES ('1471675323253432321', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-17 10:55:14', '2021-12-17 10:55:14');
INSERT INTO `rc_log` VALUES ('1472335954256613378', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-19 06:40:20', '2021-12-19 06:40:20');
INSERT INTO `rc_log` VALUES ('1472335954281779202', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-19 06:40:20', '2021-12-19 06:40:20');
INSERT INTO `rc_log` VALUES ('1472395524840660993', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-19 10:37:03', '2021-12-19 10:37:03');
INSERT INTO `rc_log` VALUES ('1472533704759877633', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-19 19:46:08', '2021-12-19 19:46:08');
INSERT INTO `rc_log` VALUES ('1473020728113639425', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-21 04:01:23', '2021-12-21 04:01:23');
INSERT INTO `rc_log` VALUES ('1473416485262077953', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-22 06:13:59', '2021-12-22 06:13:59');
INSERT INTO `rc_log` VALUES ('1473795297745383426', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-23 07:19:15', '2021-12-23 07:19:15');
INSERT INTO `rc_log` VALUES ('1475232290140004354', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-27 06:29:21', '2021-12-27 06:29:21');
INSERT INTO `rc_log` VALUES ('1475252036956790786', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-27 07:47:49', '2021-12-27 07:47:49');
INSERT INTO `rc_log` VALUES ('1475619127266652161', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-28 08:06:30', '2021-12-28 08:06:30');
INSERT INTO `rc_log` VALUES ('1475962687782035457', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-29 06:51:41', '2021-12-29 06:51:41');
INSERT INTO `rc_log` VALUES ('1476330859857133569', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2021-12-30 07:14:40', '2021-12-30 07:14:40');
INSERT INTO `rc_log` VALUES ('1477047906920833025', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2022-01-01 06:43:57', '2022-01-01 06:43:57');
INSERT INTO `rc_log` VALUES ('1478487766399500289', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2022-01-05 06:05:27', '2022-01-05 06:05:27');
INSERT INTO `rc_log` VALUES ('1478502324056932354', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2022-01-05 07:03:18', '2022-01-05 07:03:18');
INSERT INTO `rc_log` VALUES ('1480650792607182849', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2022-01-11 05:20:32', '2022-01-11 05:20:32');
INSERT INTO `rc_log` VALUES ('1481016292935843841', 10000, NULL, NULL, NULL, '{\"username\":\"admin\"}', '2022-01-12 05:32:54', '2022-01-12 05:32:54');
INSERT INTO `rc_log` VALUES ('2', 10000, '1289333755057299456', 'chenwei', '陈伟', NULL, '2020-08-09 09:44:11', '2020-08-09 09:44:11');
COMMIT;

-- ----------------------------
-- Table structure for rc_menu
-- ----------------------------
DROP TABLE IF EXISTS `rc_menu`;
CREATE TABLE `rc_menu` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `parentId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父ID',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图标',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路径',
  `sortNumber` int DEFAULT '0' COMMENT '排序',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单';

-- ----------------------------
-- Records of rc_menu
-- ----------------------------
BEGIN;
INSERT INTO `rc_menu` VALUES ('1292641517126651904', NULL, 'el-icon-menu', '系统', NULL, 100, '2020-08-10 10:02:36', '2021-12-17 12:00:11');
INSERT INTO `rc_menu` VALUES ('1292641813957533696', '1292641517126651904', 'el-icon-menu', '用户管理', '/settings/userManagement', 1, '2020-08-10 10:00:05', '2020-08-22 10:59:22');
INSERT INTO `rc_menu` VALUES ('1293148392603602944', '1292641517126651904', 'el-icon-menu', '日志管理', '/settings/logManagement', 2, '2020-08-11 19:33:08', '2020-08-22 11:25:51');
INSERT INTO `rc_menu` VALUES ('1293344897226575872', '1292641517126651904', 'el-icon-menu', '公司设置', '/settings/systemConfiguration', 3, '2020-08-12 08:33:55', '2020-08-21 17:15:28');
INSERT INTO `rc_menu` VALUES ('1293383299260801024', '1292641517126651904', 'el-icon-menu', '分类管理', '/settings/category', 4, '2020-08-12 11:14:49', '2020-08-12 11:15:07');
INSERT INTO `rc_menu` VALUES ('1296631098853076992', NULL, 'el-icon-menu', '基础', NULL, 99, '2020-08-21 10:12:07', '2021-12-17 12:00:08');
INSERT INTO `rc_menu` VALUES ('1296631306072633344', '1296631098853076992', 'el-icon-menu', '账户管理', '/basic/settlementAccount', 1, '2020-08-21 10:12:53', '2020-08-21 10:13:24');
INSERT INTO `rc_menu` VALUES ('1296722901453549568', '1296631098853076992', 'el-icon-menu', '仓库管理', '/basic/warehouseManagement', 2, '2020-08-21 16:16:56', '2020-08-21 16:18:50');
INSERT INTO `rc_menu` VALUES ('1296732201219649536', '1296631098853076992', 'el-icon-menu', '职员管理', '/basic/employeeManagement', 3, '2020-08-21 16:53:52', '2020-08-22 10:34:39');
INSERT INTO `rc_menu` VALUES ('1296964119538180096', '1292641517126651904', 'el-icon-menu', '计量单位', '/settings/unitManagement', 5, '2020-08-22 08:15:37', '2020-08-22 08:16:17');
INSERT INTO `rc_menu` VALUES ('1296969737263136768', '1292641517126651904', 'el-icon-menu', '结算方式', '/settings/settlementManagement', 6, '2020-08-22 08:38:22', '2020-08-22 08:38:53');
INSERT INTO `rc_menu` VALUES ('1296999025850773504', '1296631098853076992', 'el-icon-menu', '客户管理', '/basic/customerManagement', 4, '2020-08-22 10:34:10', '2020-08-22 10:34:42');
INSERT INTO `rc_menu` VALUES ('1297366403820650496', '1296631098853076992', 'el-icon-menu', '供应商管理', '/basic/supplierManagement', 5, '2020-08-23 10:54:05', '2020-08-23 10:55:40');
INSERT INTO `rc_menu` VALUES ('1298062543123435520', '1296631098853076992', 'el-icon-menu', '商品管理', '/basic/productManagement', 6, '2020-08-25 09:00:14', '2020-08-25 09:00:35');
INSERT INTO `rc_menu` VALUES ('1299239167831339008', NULL, 'el-icon-menu', '购货', NULL, 1, '2020-08-28 14:57:56', '2021-12-17 08:47:25');
INSERT INTO `rc_menu` VALUES ('1299239898722369536', '1299239167831339008', 'el-icon-menu', '购货单列表', '/purchase/list', 1, '2020-08-28 14:59:18', '2020-08-28 14:59:35');
INSERT INTO `rc_menu` VALUES ('1300698490747011072', '1299239167831339008', 'el-icon-menu', '购货单新增', '/purchase/save', 2, '2020-09-01 15:34:52', '2020-09-01 15:34:52');
INSERT INTO `rc_menu` VALUES ('1315073805501968384', '1299239167831339008', 'el-icon-menu', '退货单列表', '/refund/list', 3, '2020-10-11 07:36:58', '2020-10-11 07:38:26');
INSERT INTO `rc_menu` VALUES ('1315074032980054016', '1299239167831339008', 'el-icon-menu', '退货单新增', '/refund/save', 4, '2020-10-11 07:37:43', '2020-10-11 07:38:29');
INSERT INTO `rc_menu` VALUES ('1384289028173586432', NULL, 'el-icon-menu', '销货', NULL, 2, '2021-04-20 07:33:29', '2021-12-17 08:47:20');
INSERT INTO `rc_menu` VALUES ('1384289183773843456', '1384289028173586432', 'el-icon-menu', '客户订单列表', '/order/list', 1, '2021-04-20 07:34:03', '2021-12-30 15:29:50');
INSERT INTO `rc_menu` VALUES ('1384289905148030976', '1384289028173586432', 'el-icon-menu', '客户订单新增', '/order/save', 2, '2021-04-20 07:37:01', '2021-12-30 15:29:53');
INSERT INTO `rc_menu` VALUES ('1471232280943558656', '1384289028173586432', 'el-icon-menu', '销货单列表', '/sell/list', 3, '2021-12-16 05:34:58', '2021-12-16 05:35:27');
INSERT INTO `rc_menu` VALUES ('1471232482723160064', '1384289028173586432', 'el-icon-menu', '销货单新增', '/sell/save', 4, '2021-12-16 05:35:39', '2021-12-16 05:35:59');
INSERT INTO `rc_menu` VALUES ('1471328626560135168', '1384289028173586432', 'el-icon-menu', '销货退货单列表', '/returned/list', 5, '2021-12-16 11:57:50', '2021-12-16 11:58:09');
INSERT INTO `rc_menu` VALUES ('1471328791773753344', '1384289028173586432', 'el-icon-menu', '销货退货单新增', '/returned/save', 6, '2021-12-16 11:58:20', '2021-12-16 11:58:39');
INSERT INTO `rc_menu` VALUES ('1471642824032866304', NULL, 'el-icon-menu', '仓库', NULL, 3, '2021-12-17 08:46:17', '2021-12-17 08:47:35');
INSERT INTO `rc_menu` VALUES ('1471643231677263872', '1471642824032866304', 'el-icon-menu', '调拨单列表', '/transfer/list', 1, '2021-12-17 08:47:52', '2021-12-17 08:48:51');
INSERT INTO `rc_menu` VALUES ('1471643555553050624', '1471642824032866304', 'el-icon-menu', '调拨单新增', '/transfer/save', 2, '2021-12-17 08:49:15', '2021-12-17 08:50:59');
INSERT INTO `rc_menu` VALUES ('1471643599488352256', '1471642824032866304', 'el-icon-menu', '其他入库单列表', '/store/list', 3, '2021-12-17 08:49:19', '2021-12-17 08:51:01');
INSERT INTO `rc_menu` VALUES ('1471643657323622400', '1471642824032866304', 'el-icon-menu', '其他入库单新增', '/store/save', 4, '2021-12-17 08:49:29', '2021-12-17 08:51:04');
INSERT INTO `rc_menu` VALUES ('1471643692463513600', '1471642824032866304', 'el-icon-menu', '其他出库单列表', '/checkout/list', 5, '2021-12-17 08:49:36', '2021-12-17 08:51:07');
INSERT INTO `rc_menu` VALUES ('1471643725019668480', '1471642824032866304', 'el-icon-menu', '其他出库单新增', '/checkout/save', 6, '2021-12-17 08:49:44', '2021-12-17 08:51:09');
INSERT INTO `rc_menu` VALUES ('1471691384556298240', NULL, 'el-icon-menu', '资金', NULL, 4, '2021-12-17 11:59:14', '2021-12-28 08:47:56');
INSERT INTO `rc_menu` VALUES ('1471691498104516608', NULL, 'el-icon-menu', '报表', NULL, 5, '2021-12-17 11:59:36', '2021-12-29 06:51:27');
INSERT INTO `rc_menu` VALUES ('1472394810403872768', '1471691384556298240', 'el-icon-menu', '收款单列表', '/collection/list', 1, '2021-12-19 10:34:23', '2021-12-19 10:34:51');
INSERT INTO `rc_menu` VALUES ('1472394985604136960', '1471691384556298240', 'el-icon-menu', '收款单新增', '/collection/save', 2, '2021-12-19 10:35:01', '2021-12-19 10:35:18');
INSERT INTO `rc_menu` VALUES ('1475245908768616448', '1471691384556298240', 'el-icon-menu', '付款单列表', '/payment/list', 3, '2021-12-27 07:23:37', '2021-12-27 07:24:28');
INSERT INTO `rc_menu` VALUES ('1475245992910557184', '1471691384556298240', 'el-icon-menu', '付款单新增', '/payment/save', 4, '2021-12-27 07:23:53', '2021-12-27 07:24:30');
INSERT INTO `rc_menu` VALUES ('1475618763327008768', '1471691384556298240', 'el-icon-menu', '其他收入单列表', '/income/list', 5, '2021-12-28 08:05:08', '2021-12-28 08:05:29');
INSERT INTO `rc_menu` VALUES ('1475618890485714944', '1471691384556298240', 'el-icon-menu', '其他收入单新增', '/income/save', 6, '2021-12-28 08:05:37', '2021-12-28 08:06:00');
INSERT INTO `rc_menu` VALUES ('1475629486652272640', '1471691384556298240', 'el-icon-menu', '其他支出单列表', '/expense/list', 7, '2021-12-28 08:48:09', '2021-12-28 08:48:49');
INSERT INTO `rc_menu` VALUES ('1475629591690256384', '1471691384556298240', 'el-icon-menu', '其他支出单新增', '/expense/save', 8, '2021-12-28 08:48:12', '2021-12-28 08:48:52');
INSERT INTO `rc_menu` VALUES ('1475962385566056448', '1471691498104516608', 'el-icon-menu', '采购明细表', '/analysis/purchaseDetail', 1, '2021-12-29 06:50:45', '2021-12-29 06:51:21');
INSERT INTO `rc_menu` VALUES ('1476333325822984192', '1471691498104516608', 'el-icon-menu', '采购汇总表(按商品)', '/analysis/purchaseProductSummary', 2, '2021-12-30 07:24:45', '2021-12-30 07:26:34');
INSERT INTO `rc_menu` VALUES ('1476349643430993920', '1471691498104516608', 'el-icon-menu', '采购汇总表(按供应商)', '/analysis/purchaseSupplierSummary', 3, '2021-12-30 08:29:30', '2021-12-30 08:30:19');
INSERT INTO `rc_menu` VALUES ('1476356352144719872', '1471691498104516608', 'el-icon-menu', '销售明细表', '/analysis/saleDetail', 4, '2021-12-30 08:56:05', '2021-12-30 08:56:51');
INSERT INTO `rc_menu` VALUES ('1476376463404605440', '1471691498104516608', 'el-icon-menu', '销售汇总表(按商品)', '/analysis/saleProductSummary', 5, '2021-12-30 10:15:59', '2021-12-30 10:17:31');
INSERT INTO `rc_menu` VALUES ('1476376678455341056', '1471691498104516608', 'el-icon-menu', '销售汇总表(按客户)', '/analysis/saleCustomerSummary', 6, '2021-12-30 10:16:48', '2021-12-30 10:17:33');
INSERT INTO `rc_menu` VALUES ('1477455884043948032', '1471691498104516608', 'el-icon-menu', '收发明细表', '/analysis/stockDetail', 7, '2022-01-02 09:45:18', '2022-01-02 09:45:43');
INSERT INTO `rc_menu` VALUES ('1478488730833526784', '1471691498104516608', 'el-icon-menu', '库存余额表', '/analysis/stockAmount', 8, '2022-01-05 06:09:26', '2022-01-05 06:09:59');
INSERT INTO `rc_menu` VALUES ('1480655393402150912', '1471691498104516608', 'el-icon-menu', '收发汇总表', '/analysis/stockSummary', 9, '2022-01-11 05:39:03', '2022-01-11 05:39:32');
INSERT INTO `rc_menu` VALUES ('1480718299934314496', '1471691498104516608', 'el-icon-menu', '现金银行报表', '/analysis/accountDetail', 10, '2022-01-11 09:48:57', '2022-01-11 09:49:25');
INSERT INTO `rc_menu` VALUES ('1481044165688066048', '1471691498104516608', 'el-icon-menu', '应收账款明细表', '/analysis/receivableDetail', 11, '2022-01-12 07:23:47', '2022-01-12 07:24:16');
INSERT INTO `rc_menu` VALUES ('1481050245784694784', '1471691498104516608', 'el-icon-menu', '应付账款明细表', '/analysis/payableDetail', 12, '2022-01-12 07:47:56', '2022-01-12 07:48:29');
INSERT INTO `rc_menu` VALUES ('1481063995791155200', '1471691498104516608', 'el-icon-menu', '客户对账单', '/analysis/receivableCustomer', 13, '2022-01-12 08:42:37', '2022-01-12 08:43:06');
INSERT INTO `rc_menu` VALUES ('1481068835057475584', '1471691498104516608', 'el-icon-menu', '供应商对账单', '/analysis/payableSupplier', 14, '2022-01-12 09:01:51', '2022-01-12 09:02:17');
INSERT INTO `rc_menu` VALUES ('1481091192387727360', '1471691498104516608', 'el-icon-menu', '其他收支明细表', '/analysis/flowDetail', 15, '2022-01-12 10:30:42', '2022-01-12 10:31:02');
COMMIT;

-- ----------------------------
-- Table structure for uc_customer
-- ----------------------------
DROP TABLE IF EXISTS `uc_customer`;
CREATE TABLE `uc_customer` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `categoryId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户类别ID',
  `level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '10' COMMENT '客户等级ID',
  `balanceTime` timestamp NULL DEFAULT NULL COMMENT '余额日期',
  `beginReceivableAmount` bigint DEFAULT NULL COMMENT '期初应收款',
  `beginPrepaidAmount` bigint DEFAULT NULL COMMENT '期初预收款',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户';

-- ----------------------------
-- Records of uc_customer
-- ----------------------------
BEGIN;
INSERT INTO `uc_customer` VALUES ('1295569375012671489', 'chenliu', '张三', '1293513956037320706', '1294753269708566530', '2020-08-18 03:53:02', 0, 10000, NULL, b'1', '2020-08-18 11:53:04', '2020-08-18 14:39:05');
INSERT INTO `uc_customer` VALUES ('1295606388080279553', 'lisi', '张三', '1293513956037320706', '1294753269708566530', '2020-08-18 06:20:06', 0, 10000, NULL, b'0', '2020-08-18 14:20:08', '2020-08-18 14:39:09');
INSERT INTO `uc_customer` VALUES ('1297740008892768257', '002', '沃尔玛', '1', '1294753669664813058', '2020-08-03 16:00:00', 1111, 1111, '没什么问题', b'1', '2020-08-24 11:38:23', '2020-08-24 11:38:23');
INSERT INTO `uc_customer` VALUES ('1297749444482834433', '1341234', '314124', '2', '1294753669664813058', '2020-08-18 16:00:00', 0, 0, NULL, b'1', '2020-08-24 12:15:53', '2020-08-24 12:15:53');
INSERT INTO `uc_customer` VALUES ('1297749816278523905', '132414', '324134', '1293513956037320706', '1294753575536242689', NULL, 134100, 21412400, NULL, b'1', '2020-08-24 12:17:21', '2020-08-24 12:17:21');
INSERT INTO `uc_customer` VALUES ('1297749970645688322', '1243234', '3241234', '1293515038924996609', '1294753575536242689', '2020-08-23 16:00:00', 134123400, 123431400, NULL, b'1', '2020-08-24 12:17:58', '2020-08-24 12:17:58');
INSERT INTO `uc_customer` VALUES ('1297750563326009346', 'f134', '134', '2', '1294753575536242689', NULL, 0, 0, NULL, b'1', '2020-08-24 12:20:19', '2020-08-24 12:20:19');
INSERT INTO `uc_customer` VALUES ('1297751015622975490', '1234', '1432', '1293513956037320706', '1294753669664813058', NULL, 12300, 23100, NULL, b'1', '2020-08-24 12:22:07', '2020-08-24 12:22:07');
INSERT INTO `uc_customer` VALUES ('1297751294850375682', '134', '3241411', '2', '1294753269708566530', '2020-08-18 16:00:00', 11100, 1234100, NULL, b'0', '2020-08-24 12:23:14', '2020-08-24 12:23:14');
INSERT INTO `uc_customer` VALUES ('1297792593699852290', '134121', '32412341341', '1293513956037320706', '1294753575536242689', NULL, 100, 123400, '测是', b'1', '2020-08-24 15:07:20', '2020-08-24 15:07:20');
INSERT INTO `uc_customer` VALUES ('1471264427976871937', '0001', '永辉', '1293513956037320706', '1294753269708566530', '2021-12-15 16:00:00', 10000, 1000000, NULL, b'1', '2021-12-16 07:42:29', '2021-12-16 07:42:29');
COMMIT;

-- ----------------------------
-- Table structure for uc_customer_contact
-- ----------------------------
DROP TABLE IF EXISTS `uc_customer_contact`;
CREATE TABLE `uc_customer_contact` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `customerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '座机',
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '职位',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'QQ',
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '地址',
  `primary` bit(1) DEFAULT b'0' COMMENT '是否首要联系人',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户联系人';

-- ----------------------------
-- Records of uc_customer_contact
-- ----------------------------
BEGIN;
INSERT INTO `uc_customer_contact` VALUES ('1295606388424212482', '1295606388080279553', '张三', '1888888888', '0591-88888888', '总经理', '4057723', '福建福州长乐区国家博物馆1号', b'1', '2020-08-18 14:20:08', '2020-08-22 10:50:26');
INSERT INTO `uc_customer_contact` VALUES ('1295606388436795394', '1295606388080279553', '张三', '16666666666', NULL, '董事长', NULL, NULL, b'0', '2020-08-18 14:20:08', '2020-08-18 14:37:26');
INSERT INTO `uc_customer_contact` VALUES ('1297740010092339202', '1297740008892768257', '张三', '189304143', NULL, NULL, NULL, '长乐', b'1', '2020-08-24 11:38:23', '2020-08-24 11:38:23');
INSERT INTO `uc_customer_contact` VALUES ('1297749816832172033', '1297749816278523905', '134', '34124', '321414', '43414', '4341234', '14321243', b'1', '2020-08-24 12:17:22', '2020-08-24 12:17:22');
INSERT INTO `uc_customer_contact` VALUES ('1297793924904833026', '1297792593699852290', 'dsfafa', 'dsfasdf', 'dsfadsfa', NULL, NULL, 'adfafa', b'1', '2020-08-24 15:12:38', '2020-08-24 15:12:38');
INSERT INTO `uc_customer_contact` VALUES ('1471264428186587137', '1471264427976871937', '张无忌', '1888888888', '0712-19387123', NULL, NULL, '北京故宫', b'1', '2021-12-16 07:42:29', '2021-12-16 07:42:29');
INSERT INTO `uc_customer_contact` VALUES ('1471264595723866113', '1471264427976871937', '李四光', '134813244', '9287-1939138', NULL, NULL, '天津虎门', b'0', '2021-12-16 07:43:09', '2021-12-16 07:43:09');
COMMIT;

-- ----------------------------
-- Table structure for uc_employee
-- ----------------------------
DROP TABLE IF EXISTS `uc_employee`;
CREATE TABLE `uc_employee` (
  `id` bigint NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='职员';

-- ----------------------------
-- Records of uc_employee
-- ----------------------------
BEGIN;
INSERT INTO `uc_employee` VALUES (1295142029516341249, 'chenwei', '陈伟', b'1', '2020-08-17 07:34:57', '2020-08-17 07:34:57');
INSERT INTO `uc_employee` VALUES (1295142572955648001, 'lisiguang', '李四光', b'0', '2020-08-17 07:37:06', '2020-08-17 07:37:06');
COMMIT;

-- ----------------------------
-- Table structure for uc_product
-- ----------------------------
DROP TABLE IF EXISTS `uc_product`;
CREATE TABLE `uc_product` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `barcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '条码',
  `spec` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格',
  `categoryId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类别ID',
  `primaryWarehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '首选仓库ID',
  `unitId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计量单位ID',
  `retailPrice` double DEFAULT NULL COMMENT '零售价',
  `wholesalePrice` double DEFAULT NULL COMMENT '批发价',
  `vipPrice` double DEFAULT NULL COMMENT 'VIP价格',
  `discountRate1` double DEFAULT NULL COMMENT '折扣率1',
  `discountRate2` double DEFAULT NULL COMMENT '折扣率2',
  `estimatedPurchasePrice` double DEFAULT NULL COMMENT '预计采购价',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `minimumStock` double DEFAULT NULL COMMENT '最低库存',
  `maximumStock` double DEFAULT NULL COMMENT '最高库存',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品';

-- ----------------------------
-- Records of uc_product
-- ----------------------------
BEGIN;
INSERT INTO `uc_product` VALUES ('1298462990858530818', '1111', 'test', '11111', '皇帝蕉', '1293531582908334081', '1295255465562857473', '1296969005835337730', 11, 11, 123.3, 11, 11, 1233, 'aaa', 111, 12223, b'1', '2020-08-26 11:31:15', '2020-08-26 11:31:15');
INSERT INTO `uc_product` VALUES ('1300966921455050754', '002', '苹果', '12341234', 'ada', '1292436543931158529', '1295255465562857473', '1292601958565150721', 111, 111, 11, 11, 11, 11, NULL, NULL, NULL, b'1', '2020-09-02 09:20:59', '2020-09-02 09:20:59');
INSERT INTO `uc_product` VALUES ('1300967026824355842', '003', '芒果', '1234134', '131', '1293531582908334081', '1295255465562857473', '1292601958565150721', 123, 12, 23, 11, 11, 11, '11', NULL, NULL, b'1', '2020-09-02 09:21:24', '2020-09-02 09:21:24');
COMMIT;

-- ----------------------------
-- Table structure for uc_settlement_account
-- ----------------------------
DROP TABLE IF EXISTS `uc_settlement_account`;
CREATE TABLE `uc_settlement_account` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账户编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账户名称',
  `balanceTime` timestamp NULL DEFAULT NULL COMMENT '余额日期',
  `beginBalance` double DEFAULT '0' COMMENT '期初余额',
  `currentBalance` double DEFAULT '0' COMMENT '当前余额',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账户类别',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='结算账户';

-- ----------------------------
-- Records of uc_settlement_account
-- ----------------------------
BEGIN;
INSERT INTO `uc_settlement_account` VALUES ('1295128579910197250', 'ICBC01', '工商银行1号111', '2020-08-16 22:41:27', 100000, 98078, '1294765881575636993', '2020-08-17 06:41:30', '2020-08-17 06:41:30');
INSERT INTO `uc_settlement_account` VALUES ('1296693080669302785', 'ICBC02', '工商银行2号', '2020-08-21 06:18:12', 10000000, 10001112, '1294765881575636993', '2020-08-21 14:18:16', '2020-08-21 14:18:16');
INSERT INTO `uc_settlement_account` VALUES ('1296693882423103490', 'ICBC02', '工商银行2号11', '2020-08-21 06:21:24', 10000000, 10000000, '1294765881575636993', '2020-08-21 14:21:27', '2020-08-21 14:21:27');
INSERT INTO `uc_settlement_account` VALUES ('1296694402999144450', 'ICBC03', '工商银行3号', '2020-08-20 16:00:00', 111111, 110781, '1294765881575636993', '2020-08-21 14:23:31', '2020-08-21 14:23:31');
INSERT INTO `uc_settlement_account` VALUES ('1296701339455201282', 'ces1', '测试111', '2020-08-20 16:00:00', 11111, 11111, '1294765881575636993', '2020-08-21 14:51:05', '2020-08-21 14:51:05');
COMMIT;

-- ----------------------------
-- Table structure for uc_supplier
-- ----------------------------
DROP TABLE IF EXISTS `uc_supplier`;
CREATE TABLE `uc_supplier` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `categoryId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户类别ID',
  `balanceTime` timestamp NULL DEFAULT NULL COMMENT '余额日期',
  `beginReceivableAmount` bigint DEFAULT NULL COMMENT '期初应收款',
  `beginPrepaidAmount` bigint DEFAULT NULL COMMENT '期初预收款',
  `vatRate` smallint DEFAULT NULL COMMENT '增值税税率',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商';

-- ----------------------------
-- Records of uc_supplier
-- ----------------------------
BEGIN;
INSERT INTO `uc_supplier` VALUES ('1295709005540245506', 'lisi', '李四', '1293527068016902146', '2020-08-18 13:07:53', 0, 10000, 17, '很好的供应商', b'1', '2020-08-18 21:07:54', '2020-08-18 21:07:54');
INSERT INTO `uc_supplier` VALUES ('1297813081146834946', 'daf', 'asdfasf', '1297806472534364162', '2020-08-10 16:00:00', 12341201, 412300, 17, '234123', b'1', '2020-08-24 16:28:45', '2020-08-24 16:28:45');
COMMIT;

-- ----------------------------
-- Table structure for uc_supplier_contact
-- ----------------------------
DROP TABLE IF EXISTS `uc_supplier_contact`;
CREATE TABLE `uc_supplier_contact` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '座机',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'QQ',
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '地址',
  `primary` bit(1) DEFAULT b'0' COMMENT '是否首要联系人',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商联系人';

-- ----------------------------
-- Records of uc_supplier_contact
-- ----------------------------
BEGIN;
INSERT INTO `uc_supplier_contact` VALUES ('1295709006299414530', '1295709005540245506', '张三', '1888888888', NULL, NULL, NULL, b'1', '2020-08-18 21:07:54', '2020-08-18 21:07:54');
INSERT INTO `uc_supplier_contact` VALUES ('1295709006383300610', '1295709005540245506', '李四', '16666666666', NULL, NULL, NULL, b'0', '2020-08-18 21:07:54', '2020-08-18 21:07:54');
INSERT INTO `uc_supplier_contact` VALUES ('1297813081918586882', '1297813081146834946', '1243', '2134', '234214', '13241', '341', b'1', '2020-08-24 16:28:45', '2020-08-24 16:28:45');
COMMIT;

-- ----------------------------
-- Table structure for uc_user
-- ----------------------------
DROP TABLE IF EXISTS `uc_user`;
CREATE TABLE `uc_user` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `mobile` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '真实姓名',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `deleted` bit(1) DEFAULT b'0' COMMENT '是否删除',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户';

-- ----------------------------
-- Records of uc_user
-- ----------------------------
BEGIN;
INSERT INTO `uc_user` VALUES ('1289333207897759744', '陈伟', '18988888888', NULL, '李四', b'1', b'0', '2020-08-01 06:52:46', '2020-09-01 14:29:12');
INSERT INTO `uc_user` VALUES ('1289333755057299456', '陈伟', '18988888888', '$2a$10$x4npLQ6ubMA2R1pG6IDX5.6y9EIatAqSyhfPZr0pvjMO8W9UzanwS', '王五', b'0', b'0', '2020-08-01 06:54:56', '2020-09-01 14:29:12');
INSERT INTO `uc_user` VALUES ('1291929781444599810', 'admin', '18905013333', '$2a$10$u3B/LOj.mMWZv4ZchquGRefcGtwGBHZrs4VLAzGdliv41bhtuPXOm', '张三', b'0', b'0', '2020-08-08 10:50:37', '2020-08-10 09:46:28');
INSERT INTO `uc_user` VALUES ('1292285182061146114', 'chenwei', '18905015555', '$2a$10$rsACDOKKZcV.k.fV77r4IeOXEHHeIc2TcioDKO7/Rfs3HydO9LR5q', '陈伟', b'0', b'0', '2020-08-09 10:22:51', '2020-08-09 10:22:51');
INSERT INTO `uc_user` VALUES ('1292662273013186561', 'zhangsan', '13333333333', '$2a$10$vv0oZEJi1rpzo.Ibbw66nOIfJ5//kBKAJGTQG0ZUbReqwt8q6ZUwe', '张三', b'0', b'0', '2020-08-10 11:21:17', '2020-08-10 11:21:17');
INSERT INTO `uc_user` VALUES ('1293111136996114434', 'lisi11', '13345678909', '$2a$10$wTfDzDXSKFVqdB8jSm/ssOGn.XCoue2l0sceT2TdOHw9FuXU/SiiK', '李四', b'0', b'0', '2020-08-11 17:04:54', '2020-08-11 17:04:54');
INSERT INTO `uc_user` VALUES ('1468346983385829377', 'test1', '18835891234', '$2a$10$DMSQzKwNSRcY77hEAo8/GOwkUPytJTdvUT5qugjewPe1QEPTqNnIa', '张三', b'0', b'0', '2021-12-08 06:29:36', '2021-12-08 06:29:36');
INSERT INTO `uc_user` VALUES ('1468347825555935233', 'chenwei11', '18905015556', '$2a$10$NB3o43okWC.Bl86gFJOTNOhrjHJUVgrgWnPU26pj6KKKpwPD6xV26', '陈伟', b'0', b'0', '2021-12-08 06:32:56', '2021-12-08 06:32:56');
COMMIT;

-- ----------------------------
-- Table structure for uc_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `uc_warehouse`;
CREATE TABLE `uc_warehouse` (
  `id` bigint NOT NULL COMMENT 'ID主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `active` bit(1) DEFAULT b'1' COMMENT '是否启用',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='仓库';

-- ----------------------------
-- Records of uc_warehouse
-- ----------------------------
BEGIN;
INSERT INTO `uc_warehouse` VALUES (1295254961130692610, 'changle', '长乐', b'1', '2020-08-17 15:03:42', '2020-08-17 15:03:42');
INSERT INTO `uc_warehouse` VALUES (1295255465562857473, 'taijiang', '台江', b'0', '2020-08-17 15:05:42', '2020-08-17 15:05:42');
INSERT INTO `uc_warehouse` VALUES (1296731301306445825, 'cangshan', '仓山', b'1', '2020-08-21 16:50:08', '2020-08-21 16:50:08');
INSERT INTO `uc_warehouse` VALUES (1296731332751142913, 'fuqing', '福清', b'0', '2020-08-21 16:50:16', '2020-08-21 16:50:16');
INSERT INTO `uc_warehouse` VALUES (1296731380834643970, 'lianjiang', '连江', b'1', '2020-08-21 16:50:27', '2020-08-21 16:50:27');
INSERT INTO `uc_warehouse` VALUES (1296731429211746306, 'sanming', '三明', b'1', '2020-08-21 16:50:39', '2020-08-21 16:50:39');
COMMIT;

-- ----------------------------
-- Table structure for wc_checkout
-- ----------------------------
DROP TABLE IF EXISTS `wc_checkout`;
CREATE TABLE `wc_checkout` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `type` smallint DEFAULT '10' COMMENT '类型：10、其他入库 20、盘亏',
  `customerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户ID',
  `amount` double DEFAULT NULL COMMENT '出库成本',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='出库';

-- ----------------------------
-- Records of wc_checkout
-- ----------------------------
BEGIN;
INSERT INTO `wc_checkout` VALUES ('1471687422897737729', '2021-12-15', 'CK2021121711430241164', 10, '1471264427976871937', 10, 11, NULL, NULL, '2021-12-17 11:43:18', '2021-12-17 11:43:18');
INSERT INTO `wc_checkout` VALUES ('1471689784441901057', '2021-12-17', 'CK2021121711522585543', 10, '1471264427976871937', 10, 11, NULL, NULL, '2021-12-17 11:52:41', '2021-12-17 11:52:41');
INSERT INTO `wc_checkout` VALUES ('1476464876992892929', '2021-12-30', 'CK2021123016065187820', 10, '1471264427976871937', 10, 11, NULL, NULL, '2021-12-30 16:07:12', '2021-12-30 16:07:12');
COMMIT;

-- ----------------------------
-- Table structure for wc_issue_product
-- ----------------------------
DROP TABLE IF EXISTS `wc_issue_product`;
CREATE TABLE `wc_issue_product` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `productId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品ID',
  `warehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仓库ID',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `price` double DEFAULT NULL COMMENT '单价',
  `discountRate` double DEFAULT NULL COMMENT '折扣率',
  `discountAmount` double DEFAULT NULL COMMENT '折扣额',
  `amount` double DEFAULT NULL COMMENT '金额',
  `code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '序列号',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='单据商品';

-- ----------------------------
-- Records of wc_issue_product
-- ----------------------------
BEGIN;
INSERT INTO `wc_issue_product` VALUES ('1471260072754188289', NULL, NULL, '1471260072359923713', '1300967026824355842', '1295254961130692610', 111, 1111, 110, 110, 111, '111', '1111', '2021-12-16 07:25:10', '2021-12-16 07:25:10');
INSERT INTO `wc_issue_product` VALUES ('1476438132122492929', NULL, 'sell', '1473043894923988993', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '111', '1111', '2021-12-30 14:20:56', '2021-12-30 14:20:56');
INSERT INTO `wc_issue_product` VALUES ('1476438132139270145', NULL, 'sell', '1473043894923988993', '1300966921455050754', '1295254961130692610', 11, 10, 10, 10, 10, NULL, NULL, '2021-12-30 14:20:56', '2021-12-30 14:20:56');
INSERT INTO `wc_issue_product` VALUES ('1476441303951638529', NULL, 'returned', '1476440895887802369', '1300966921455050754', '1295255465562857473', 111, 110, 10, 10, 10, '11', 'aaaaa', '2021-12-30 14:33:32', '2021-12-30 14:33:32');
INSERT INTO `wc_issue_product` VALUES ('1476456034971901954', NULL, 'order', '1470892097228423170', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, NULL, '11111', '2021-12-30 15:32:04', '2021-12-30 15:32:04');
INSERT INTO `wc_issue_product` VALUES ('1476461730622824450', NULL, 'store', '1471680162595274754', '1300967026824355842', '1295255465562857473', 11, 10, NULL, NULL, 10, NULL, '1111', '2021-12-30 15:54:42', '2021-12-30 15:54:42');
INSERT INTO `wc_issue_product` VALUES ('1477084239047503874', NULL, 'buy', '1476388081572122626', '1300967026824355842', '1295254961130692610', 111, 110, 110, 110, 10, '111', '1111', '2022-01-01 09:08:20', '2022-01-01 09:08:20');
INSERT INTO `wc_issue_product` VALUES ('1477084349638717441', NULL, 'refund', '1476388263210651649', '1298462990858530818', '1295255465562857473', 11, 10, 10, 10, 10, '11', '111', '2022-01-01 09:08:46', '2022-01-01 09:08:46');
INSERT INTO `wc_issue_product` VALUES ('1477084384782790658', NULL, 'sell', '1473049734603116546', '1300967026824355842', '1295254961130692610', 1, 10, 10, 10, 10, '11', '111', '2022-01-01 09:08:54', '2022-01-01 09:08:54');
INSERT INTO `wc_issue_product` VALUES ('1477084405808836610', NULL, 'returned', '1476438647745060866', '1298462990858530818', '1295255465562857473', 11, 10, 10, 10, 10, '111', NULL, '2022-01-01 09:08:59', '2022-01-01 09:08:59');
INSERT INTO `wc_issue_product` VALUES ('1477084922719047682', NULL, 'checkout', '1471689784441901057', '1300967026824355842', '1295255465562857473', 11, 10, NULL, NULL, 10, NULL, NULL, '2022-01-01 09:11:03', '2022-01-01 09:11:03');
INSERT INTO `wc_issue_product` VALUES ('1477084944932081666', NULL, 'checkout', '1476464876992892929', '1300966921455050754', '1296731332751142913', 11, 10, NULL, NULL, 10, NULL, '111', '2022-01-01 09:11:08', '2022-01-01 09:11:08');
INSERT INTO `wc_issue_product` VALUES ('1477456277385895938', '2022-01-04', 'buy', '1477456276920328193', '1300966921455050754', '1295254961130692610', 100, 10, 10, 10, 10, '111', NULL, '2022-01-02 09:46:41', '2022-01-02 09:46:41');
INSERT INTO `wc_issue_product` VALUES ('1477457766921175041', '2022-01-02', 'buy', '1477457766455607298', '1298462990858530818', '1295254961130692610', 1111, 1110, 110, 10, 10, '111', NULL, '2022-01-02 09:52:36', '2022-01-02 09:52:36');
INSERT INTO `wc_issue_product` VALUES ('1477458033402085377', '2022-01-04', 'sell', '1477458033183981569', '1300966921455050754', '1295254961130692610', 111, 110, 110, 10, 10, '11', NULL, '2022-01-02 09:53:39', '2022-01-02 09:53:39');
INSERT INTO `wc_issue_product` VALUES ('1477458883659296769', '2022-01-02', 'sell', '1477458882866573313', '1300966921455050754', '1295254961130692610', 111, 10, 10, 10, 10, '11', NULL, '2022-01-02 09:57:02', '2022-01-02 09:57:02');
INSERT INTO `wc_issue_product` VALUES ('1477462545337020418', '2021-12-21', 'returned', '1473047284894781442', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '111', '1111', '2022-01-02 10:11:35', '2022-01-02 10:11:35');
INSERT INTO `wc_issue_product` VALUES ('1480692961849798658', '2022-01-11', 'buy', '1480692961497477122', '1300967026824355842', '1295254961130692610', 111, 110, 10, 10, 10, '11', NULL, '2022-01-11 08:08:06', '2022-01-11 08:08:06');
INSERT INTO `wc_issue_product` VALUES ('1480694098066272258', '2022-01-11', 'buy', '1480694097747505153', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '11', '111', '2022-01-11 08:12:37', '2022-01-11 08:12:37');
INSERT INTO `wc_issue_product` VALUES ('1480696823290130434', '2022-01-11', 'buy', '1480696822379966466', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '11', '111', '2022-01-11 08:23:27', '2022-01-11 08:23:27');
INSERT INTO `wc_issue_product` VALUES ('1480719649602269185', '2022-01-11', 'buy', '1480719649040232450', '1300967026824355842', '1295254961130692610', 111, 110, 10, 10, 10, '11', '111', '2022-01-11 09:54:09', '2022-01-11 09:54:09');
INSERT INTO `wc_issue_product` VALUES ('1480719843542691841', '2022-01-11', 'buy', '1480719843190370305', '1300966921455050754', '1295254961130692610', 111, 110, 10, 10, 10, '111', NULL, '2022-01-11 09:54:55', '2022-01-11 09:54:55');
INSERT INTO `wc_issue_product` VALUES ('1480720577676288002', '2022-01-11', 'buy', '1480720576917118977', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '111', NULL, '2022-01-11 09:57:50', '2022-01-11 09:57:50');
INSERT INTO `wc_issue_product` VALUES ('1480721233694703618', '2022-01-11', 'buy', '1480721233279467522', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '11', '11', '2022-01-11 10:00:27', '2022-01-11 10:00:27');
INSERT INTO `wc_issue_product` VALUES ('1480721652504338433', '2022-01-11', 'buy', '1480721652177182722', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '111', '1111', '2022-01-11 10:02:07', '2022-01-11 10:02:07');
INSERT INTO `wc_issue_product` VALUES ('1480723490536062978', '2022-01-11', 'buy', '1480723490150187009', '1300967026824355842', '1295254961130692610', 111, 110, 110, 10, 10, '11', '111', '2022-01-11 10:09:25', '2022-01-11 10:09:25');
INSERT INTO `wc_issue_product` VALUES ('1480724158533967873', '2022-01-12', 'buy', '1480724158248755201', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '11', '111', '2022-01-11 10:12:04', '2022-01-11 10:12:04');
INSERT INTO `wc_issue_product` VALUES ('1480724446204502018', '2022-01-10', 'sell', '1480724445915095041', '1300966921455050754', '1295254961130692610', 111, 110, 110, 110, 110, '11', '111', '2022-01-11 10:13:13', '2022-01-11 10:13:13');
INSERT INTO `wc_issue_product` VALUES ('1481031902386233345', '2022-01-03', 'sell', '1481031901291520002', '1300967026824355842', '1295254961130692610', 111, 10, 10, 10, 10, '11', '111', '2022-01-12 06:34:56', '2022-01-12 06:34:56');
INSERT INTO `wc_issue_product` VALUES ('1481032902748344321', '2022-01-12', 'returned', '1481032902165336066', '1300967026824355842', '1295255465562857473', 11, 10, 10, 10, 10, '11', '111', '2022-01-12 06:38:54', '2022-01-12 06:38:54');
INSERT INTO `wc_issue_product` VALUES ('1481037848239976449', '2022-01-12', 'buy', '1481037847870877697', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '111', '111', '2022-01-12 06:58:34', '2022-01-12 06:58:34');
INSERT INTO `wc_issue_product` VALUES ('1481038098879000578', '2022-01-12', 'buy', '1481038098631536641', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '11', '111', '2022-01-12 06:59:33', '2022-01-12 06:59:33');
INSERT INTO `wc_issue_product` VALUES ('1481038341339131906', '2022-01-12', 'refund', '1481038340957450241', '1300966921455050754', '1295254961130692610', 111, 10, 10, 10, 10, '111', '111', '2022-01-12 07:00:31', '2022-01-12 07:00:31');
INSERT INTO `wc_issue_product` VALUES ('1481039215041994753', '2022-01-12', 'refund', '1481039214475763714', '1300967026824355842', '1295254961130692610', 11, 10, 10, 10, 10, '11', '11', '2022-01-12 07:03:59', '2022-01-12 07:03:59');
COMMIT;

-- ----------------------------
-- Table structure for wc_stock
-- ----------------------------
DROP TABLE IF EXISTS `wc_stock`;
CREATE TABLE `wc_stock` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `productId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品ID',
  `warehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仓库ID',
  `quantity` double DEFAULT '0' COMMENT '数量',
  `price` double DEFAULT '0' COMMENT '单价',
  `amount` double DEFAULT '0' COMMENT '成本',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='库存商品';

-- ----------------------------
-- Records of wc_stock
-- ----------------------------
BEGIN;
INSERT INTO `wc_stock` VALUES ('1477084238875537409', '1300967026824355842', '1295254961130692610', 909, 10, 1190, '2022-01-01 09:08:20', '2022-01-01 09:08:20');
INSERT INTO `wc_stock` VALUES ('1477084349533859842', '1298462990858530818', '1295255465562857473', -222, 10, -2020, '2022-01-01 09:08:46', '2022-01-01 09:08:46');
INSERT INTO `wc_stock` VALUES ('1477084922609995778', '1300967026824355842', '1295255465562857473', 0, 10, 0, '2022-01-01 09:11:03', '2022-01-01 09:11:03');
INSERT INTO `wc_stock` VALUES ('1477084944885944322', '1300966921455050754', '1296731332751142913', 11, 10, 10, '2022-01-01 09:11:08', '2022-01-01 09:11:08');
INSERT INTO `wc_stock` VALUES ('1477456277230706689', '1300966921455050754', '1295254961130692610', -233, 10, -120, '2022-01-02 09:46:40', '2022-01-02 09:46:40');
INSERT INTO `wc_stock` VALUES ('1477457766786957313', '1298462990858530818', '1295254961130692610', 1311, 1110, 2010, '2022-01-02 09:52:36', '2022-01-02 09:52:36');
COMMIT;

-- ----------------------------
-- Table structure for wc_stock_record
-- ----------------------------
DROP TABLE IF EXISTS `wc_stock_record`;
CREATE TABLE `wc_stock_record` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `businessType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `businessId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务ID',
  `productId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品ID',
  `warehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仓库ID',
  `quantity` double DEFAULT '0' COMMENT '数量',
  `stockType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '出入库类型：in 入库 out 出库',
  `currentQuantity` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '当前数量',
  `price` double DEFAULT '0' COMMENT '单价',
  `amount` double DEFAULT '0' COMMENT '金额',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='出入库记录';

-- ----------------------------
-- Records of wc_stock_record
-- ----------------------------
BEGIN;
INSERT INTO `wc_stock_record` VALUES ('1477084238972006402', '2021-12-14', 'buy', '1476388081572122626', '1300967026824355842', '1295254961130692610', 111, 'in', '10.0', 0, 0, '2022-01-01 09:08:20', '2022-01-03 09:02:28');
INSERT INTO `wc_stock_record` VALUES ('1477084349600968705', '2021-12-15', 'refund', '1476388263210651649', '1298462990858530818', '1295255465562857473', 11, 'out', '-10.0', 0, 0, '2022-01-01 09:08:46', '2022-01-03 09:02:29');
INSERT INTO `wc_stock_record` VALUES ('1477084405783670786', '2021-12-16', 'returned', '1476438647745060866', '1298462990858530818', '1295255465562857473', 11, 'out', '-20.0', 0, 0, '2022-01-01 09:08:59', '2022-01-03 09:02:29');
INSERT INTO `wc_stock_record` VALUES ('1477084802757758977', '2021-12-17', 'transfer_out', '1471674465505681409', '1300967026824355842', '1295254961130692610', 111, 'out', '-1.0', 0, 0, '2022-01-01 09:10:34', '2022-01-06 08:19:46');
INSERT INTO `wc_stock_record` VALUES ('1477084802808090625', '2021-12-18', 'transfer_in', '1471674465505681409', '1300967026824355842', '1295254961130692610', 111, 'in', '0', 0, 0, '2022-01-01 09:10:34', '2022-01-06 08:19:49');
INSERT INTO `wc_stock_record` VALUES ('1477084944911110145', '2021-12-19', 'checkout_loss', '1476464876992892929', '1300966921455050754', '1296731332751142913', 11, 'in', '10.0', 0, 0, '2022-01-01 09:11:08', '2022-01-11 06:17:37');
INSERT INTO `wc_stock_record` VALUES ('1477457766837288962', '2022-01-02', 'buy', '1477457766455607298', '1298462990858530818', '1295254961130692610', 1111, 'in', '10.0', 0, 0, '2022-01-02 09:52:36', '2022-01-03 09:02:32');
INSERT INTO `wc_stock_record` VALUES ('1477458883567022081', '2022-01-02', 'sell', '1477458882866573313', '1300966921455050754', '1295254961130692610', 111, 'out', '-10.0', 0, 0, '2022-01-02 09:57:02', '2022-01-03 09:02:33');
INSERT INTO `wc_stock_record` VALUES ('1477462545269911554', '2021-12-21', 'returned', '1473047284894781442', '1300967026824355842', '1295254961130692610', 11, 'out', '1100.0', 0, 0, '2022-01-02 10:11:35', '2022-01-03 09:02:35');
INSERT INTO `wc_stock_record` VALUES ('1480667326364798977', '2022-01-11', 'transfer_out', '1480667326029254658', '1298462990858530818', '1295255465562857473', 100, 'out', '-122.0', 0, 0, '2022-01-11 06:26:14', '2022-01-11 06:26:14');
INSERT INTO `wc_stock_record` VALUES ('1480667326385770498', NULL, 'transfer_in', '1480667326029254658', '1298462990858530818', '1295254961130692610', 100, 'in', '0.0', 0, 0, '2022-01-11 06:26:14', '2022-01-11 06:26:14');
INSERT INTO `wc_stock_record` VALUES ('1480667892226834433', '2022-01-11', 'transfer_out', '1480667891589300226', '1298462990858530818', '1295255465562857473', 100, 'out', '-222.0', 0, 0, '2022-01-11 06:28:29', '2022-01-11 06:28:29');
INSERT INTO `wc_stock_record` VALUES ('1480667892243611649', '2022-01-11', 'transfer_in', '1480667891589300226', '1298462990858530818', '1295254961130692610', 100, 'in', '100.0', 0, 0, '2022-01-11 06:28:29', '2022-01-11 06:28:29');
INSERT INTO `wc_stock_record` VALUES ('1480692961774301185', '2022-01-11', 'buy', '1480692961497477122', '1300967026824355842', '1295254961130692610', 111, 'in', '321.0', 0, 0, '2022-01-11 08:08:06', '2022-01-11 08:08:06');
INSERT INTO `wc_stock_record` VALUES ('1480694098003357697', '2022-01-11', 'buy', '1480694097747505153', '1300967026824355842', '1295254961130692610', 111, 'in', '432.0', 0, 0, '2022-01-11 08:12:37', '2022-01-11 08:12:37');
INSERT INTO `wc_stock_record` VALUES ('1480696823151718402', '2022-01-11', 'buy', '1480696822379966466', '1300967026824355842', '1295254961130692610', 111, 'in', '543.0', 0, 0, '2022-01-11 08:23:27', '2022-01-11 08:23:27');
INSERT INTO `wc_stock_record` VALUES ('1480719649535160321', '2022-01-11', 'buy', '1480719649040232450', '1300967026824355842', '1295254961130692610', 111, 'in', '654.0', 0, 0, '2022-01-11 09:54:09', '2022-01-11 09:54:09');
INSERT INTO `wc_stock_record` VALUES ('1480719843475582978', '2022-01-11', 'buy', '1480719843190370305', '1300966921455050754', '1295254961130692610', 111, 'in', '-11.0', 0, 0, '2022-01-11 09:54:55', '2022-01-11 09:54:55');
INSERT INTO `wc_stock_record` VALUES ('1480720577504321538', '2022-01-11', 'buy', '1480720576917118977', '1300967026824355842', '1295254961130692610', 111, 'in', '765.0', 0, 0, '2022-01-11 09:57:50', '2022-01-11 09:57:50');
INSERT INTO `wc_stock_record` VALUES ('1480721233644371969', '2022-01-11', 'buy', '1480721233279467522', '1300967026824355842', '1295254961130692610', 11, 'in', '776.0', 0, 0, '2022-01-11 10:00:27', '2022-01-11 10:00:27');
INSERT INTO `wc_stock_record` VALUES ('1480721652433035265', '2022-01-11', 'buy', '1480721652177182722', '1300967026824355842', '1295254961130692610', 11, 'in', '787.0', 0, 0, '2022-01-11 10:02:07', '2022-01-11 10:02:07');
INSERT INTO `wc_stock_record` VALUES ('1480723490468954114', '2022-01-11', 'buy', '1480723490150187009', '1300967026824355842', '1295254961130692610', 111, 'in', '898.0', 0, 0, '2022-01-11 10:09:25', '2022-01-11 10:09:25');
INSERT INTO `wc_stock_record` VALUES ('1480724158487830529', '2022-01-12', 'buy', '1480724158248755201', '1300967026824355842', '1295254961130692610', 111, 'in', '1009.0', 0, 0, '2022-01-11 10:12:04', '2022-01-11 10:12:04');
INSERT INTO `wc_stock_record` VALUES ('1480724446179336194', '2022-01-10', 'sell', '1480724445915095041', '1300966921455050754', '1295254961130692610', 111, 'out', '-122.0', 0, 0, '2022-01-11 10:13:13', '2022-01-11 10:13:13');
INSERT INTO `wc_stock_record` VALUES ('1481031901832585218', '2022-01-03', 'sell', '1481031901291520002', '1300967026824355842', '1295254961130692610', 111, 'out', '898.0', 0, 0, '2022-01-12 06:34:56', '2022-01-12 06:34:56');
INSERT INTO `wc_stock_record` VALUES ('1481032902513463297', '2022-01-12', 'returned', '1481032902165336066', '1300967026824355842', '1295255465562857473', 11, 'out', '0.0', 0, 0, '2022-01-12 06:38:54', '2022-01-12 06:38:54');
INSERT INTO `wc_stock_record` VALUES ('1481037848189644802', '2022-01-12', 'buy', '1481037847870877697', '1300967026824355842', '1295254961130692610', 11, 'in', '909.0', 0, 0, '2022-01-12 06:58:34', '2022-01-12 06:58:34');
INSERT INTO `wc_stock_record` VALUES ('1481038098862223362', '2022-01-12', 'buy', '1481038098631536641', '1300967026824355842', '1295254961130692610', 11, 'in', '920.0', 0, 0, '2022-01-12 06:59:33', '2022-01-12 06:59:33');
INSERT INTO `wc_stock_record` VALUES ('1481038341221691394', '2022-01-12', 'refund', '1481038340957450241', '1300966921455050754', '1295254961130692610', 111, 'out', '-233.0', 0, 0, '2022-01-12 07:00:31', '2022-01-12 07:00:31');
INSERT INTO `wc_stock_record` VALUES ('1481039214953914370', '2022-01-12', 'refund', '1481039214475763714', '1300967026824355842', '1295254961130692610', 11, 'out', '909.0', 0, 0, '2022-01-12 07:03:59', '2022-01-12 07:03:59');
COMMIT;

-- ----------------------------
-- Table structure for wc_store
-- ----------------------------
DROP TABLE IF EXISTS `wc_store`;
CREATE TABLE `wc_store` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `type` smallint DEFAULT '10' COMMENT '类型：10、其他入库 20、盘盈',
  `supplierId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商ID',
  `amount` double DEFAULT NULL COMMENT '入库金额',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `listerId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='入库';

-- ----------------------------
-- Records of wc_store
-- ----------------------------
BEGIN;
INSERT INTO `wc_store` VALUES ('1298800372468236288', '2020-08-27', '001', 10, '1295709005540245506', 1000, 10, '1292285182061146114', '备注1', '2020-08-27 09:52:27', '2020-09-01 14:43:28');
INSERT INTO `wc_store` VALUES ('1299194995510415361', '2020-08-28', '134123413241234', 10, '1295709005540245506', 1000, 11.5, '1289333755057299456', '备注2', '2020-08-28 11:59:59', '2020-09-01 14:43:28');
INSERT INTO `wc_store` VALUES ('1299199890892328961', '2020-08-28', '134123413241234', 10, '1295709005540245506', 1000, 11.5, '1289333755057299456', '备注3', '2020-08-28 12:19:26', '2020-09-01 14:43:28');
INSERT INTO `wc_store` VALUES ('1470526255617683458', '2021-12-14', 'PL2021121406484617077', 10, '1295709005540245506', 0, NULL, NULL, NULL, '2021-12-14 06:49:15', '2021-12-14 06:49:15');
INSERT INTO `wc_store` VALUES ('1470526559264321537', '2021-12-14', 'PL2021121406501342232', 10, '1295709005540245506', 0, NULL, NULL, NULL, '2021-12-14 06:50:27', '2021-12-14 06:50:27');
INSERT INTO `wc_store` VALUES ('1470528077736587265', '2021-12-14', 'PL2021121406552388903', 10, '1295709005540245506', 10, NULL, NULL, NULL, '2021-12-14 06:56:29', '2021-12-14 06:56:29');
INSERT INTO `wc_store` VALUES ('1470531230410362881', '2021-12-14', 'PL2021121406552388903', 10, '1295709005540245506', 10111, 1, NULL, NULL, '2021-12-14 07:09:01', '2021-12-14 07:09:01');
INSERT INTO `wc_store` VALUES ('1470534740556271617', '2021-12-14', 'PL2021121407222366713', 10, '1295709005540245506', 10, 1111, NULL, NULL, '2021-12-14 07:22:58', '2021-12-14 07:22:58');
INSERT INTO `wc_store` VALUES ('1470535038901309441', '2021-12-14', 'PL2021121407235305407', 10, '1297813081146834946', 0, 1111, NULL, NULL, '2021-12-14 07:24:09', '2021-12-14 07:24:09');
INSERT INTO `wc_store` VALUES ('1470535142030856193', '2021-12-14', 'PL2021121407235305408', 10, '1295709005540245506', 0, 0, NULL, NULL, '2021-12-14 07:24:33', '2021-12-14 08:13:51');
INSERT INTO `wc_store` VALUES ('1471680162595274754', '2021-12-17', 'ST2021121711140673620', 10, '1295709005540245506', 10, 11, NULL, NULL, '2021-12-17 11:14:27', '2021-12-17 11:14:27');
COMMIT;

-- ----------------------------
-- Table structure for wc_transfer
-- ----------------------------
DROP TABLE IF EXISTS `wc_transfer`;
CREATE TABLE `wc_transfer` (
  `id` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `issueDate` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据编号',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `checked` bit(1) DEFAULT b'0' COMMENT '是否已审核',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `listerId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '制单人ID',
  `auditorId` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人ID',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='调拨单';

-- ----------------------------
-- Records of wc_transfer
-- ----------------------------
BEGIN;
INSERT INTO `wc_transfer` VALUES ('1471665140682928130', '2021-12-17', 'TF2021121710141980899', 111100, b'0', NULL, NULL, NULL, '2021-12-17 10:14:46', '2021-12-17 10:14:46');
INSERT INTO `wc_transfer` VALUES ('1471674465505681409', '2021-12-18', 'TF2021121710513145531', 111, b'0', NULL, NULL, NULL, '2021-12-17 10:51:49', '2021-12-17 10:51:49');
INSERT INTO `wc_transfer` VALUES ('1480667326029254658', '2022-01-11', 'TF2022011106255375832', 100, b'0', NULL, NULL, NULL, '2022-01-11 06:26:14', '2022-01-11 06:26:14');
INSERT INTO `wc_transfer` VALUES ('1480667891589300226', '2022-01-11', 'TF2022011106281547776', 100, b'0', NULL, NULL, NULL, '2022-01-11 06:28:29', '2022-01-11 06:28:29');
COMMIT;

-- ----------------------------
-- Table structure for wc_transfer_product
-- ----------------------------
DROP TABLE IF EXISTS `wc_transfer_product`;
CREATE TABLE `wc_transfer_product` (
  `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID主键',
  `transferId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调拨ID',
  `issueDate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单据日期',
  `productId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品ID',
  `fromWarehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调出仓库ID',
  `toWarehouseId` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调入仓库ID',
  `quantity` double DEFAULT NULL COMMENT '数量',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `createdTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatedTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='调拨商品';

-- ----------------------------
-- Records of wc_transfer_product
-- ----------------------------
BEGIN;
INSERT INTO `wc_transfer_product` VALUES ('1471665259255902210', '1471665140682928130', NULL, '1300967026824355842', '1295254961130692610', '1295255465562857473', 111100, '11111', '2021-12-17 10:15:14', '2021-12-17 10:15:14');
INSERT INTO `wc_transfer_product` VALUES ('1477084802871005185', '1471674465505681409', NULL, '1300967026824355842', '1295254961130692610', '1295254961130692610', 111, '1111', '2022-01-01 09:10:34', '2022-01-01 09:10:34');
INSERT INTO `wc_transfer_product` VALUES ('1480667326499016706', '1480667326029254658', '2022-01-11', '1298462990858530818', '1295255465562857473', '1295254961130692610', 100, '0000', '2022-01-11 06:26:14', '2022-01-11 06:26:14');
INSERT INTO `wc_transfer_product` VALUES ('1480667892293943297', '1480667891589300226', '2022-01-11', '1298462990858530818', '1295255465562857473', '1295254961130692610', 100, '1111', '2022-01-11 06:28:29', '2022-01-11 06:28:29');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
